Display name of task in column

Questions & Answers
1

Hey!
I would like to display the name of a task in a column as epic name in the picture below. How to get task name with mdx?

Screenshot 2023-03-16 105922
Screenshot 2023-03-16 1059221404×664 53 KB

2

Hi @Onur ,

A warm welcome to the eazyBI community! :tada:

To extract the description of the issues, you can define a new calculated measure and use the ExtractString() function with a regular expression. The formula for the calculated measure could look similar to the one below:

CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = 'Issue'
THEN
ExtractString(
  [Issue].CurrentHierarchyMember.Name,
  '^.+-\d+ (.+)$',
  1
)
END

Please visit the eazyBI documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com