Summary of Issue for Insight Object

Questions & Answers
1

Hello,
I have a table in Insight with data that is present in Jira issues. I would like to show the summary of those issues as a calculated measure. I’ve found a similar post here the answer was like this ->

Generate(
Filter(
  Descendants([Jira Issue].CurrentMember,[Jira Issue].[Issue]),
  [Measures].[Issues created]>0
),
[Jira Issue].CurrentMember.getstring("Status"),
","
)

However this solution is not working for me, as I am using the time dimension with a calculated member that checks if a date in the insight table is within the time period and then calculates a sum based on another value of that object in insight.
So this formula above would only show me the status of the issue in the month the object was created.
The second problem is, if I replace Status with Summary it won’t show any results.

image
image1620×890 64 KB

image
image1633×751 59.4 KB

Any help is much appreciated.

2

Hi,

the solution to have the issue for the object, regardless of the date when those are created is to override the Time dimension with the default member. The Filter function should look like this:

Filter(
  Descendants([Jira Issue].CurrentMember,[Jira Issue].[Issue]),
  ([Measures].[Issues created],
    [Time].CurrentHierarchy.DefaultMember)>0
)

The summary of the Issue is not available the same way as the Status property. It is possible to extract the Issue summary from the name of the Issue dimension member:

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

The final formula would be the following:

Generate(
Filter(
  Descendants([Jira Issue].CurrentMember,[Jira Issue].[Issue]),
  ([Measures].[Issues created],
   [Time].CurrentHierarchy.DefaultMember)>0
),
 ExtractString(
    [Jira Issue].CurrentHierarchyMember.Name,
    ".+-\d+ (.*)",1),
","
)

Kindly,
Janis eazyBI support

3

Hello Janis,
thank you so much for your explanation and solution. This worked like a charm!
Best regards,
Michael