How to remove the first 10 characters from the measure property "issue key"

Questions & Answers
1

Hello,

I have a measure property field called issue key & title which basically uses this formula:

Issue key& title:
[Issue].[Issue].getMemberNameByKey(
[Issue].[Issue].CurrentHierarchyMember.get(‘KEY’)
)

It returns me values like:

ABCD-100000 The first version of report created
ABCD-100001 The second version of report created
ABCD-100002 The third version of report created
ABCD-100003 The fourth version of report created
ABCD-100004 The fifth version of report created

I can retrieve the key details “ABCD-10000” by using this formula:
[Issue].CurrentHierarchyMember.get(‘DISPLAY_KEY’)

I would like to know how to extract the lines alone:

The first version of report created
The second version of report created
The third version of report created
The fourth version of report created
The fifth version of report created

2

Hi @Gomez,

If you have the “Issue” dimension on report rows, you can choose to show the issue key and summary, only the key, or only the summary without the key (see picture below).

Issue Display name without key
Issue Display name without key2666×1038 336 KB

If you would like to show the issue summary in some calculated measure, then you can use a string function to modify the issue’s full name.

One option is ExtractString() which would look for the text part after the issue number:

ExtractString(
  [Issue].CurrentHierarchyMember.GetCaption,
  ".+-\d+ (.*)",
  1)

Another option is Replace() which would replace the issue key with the empty string "" from the full issue name.

Replace(
  [Issue].CurrentHierarchyMember.GetCaption,
  [Issue].CurrentHierarchyMember.Get('DISPLAY_KEY'),
  "")

For more details, please on those function see the documentation:

Best,
Zane / support@eazyBI.com