Grouping the Time dimension by "Issue created"

Questions & Answers
,
1

I’m using the following “newly defined measure” to generate the total number of days tickets have been in status X:
([Measures].[Days in transition status], [Transition Status].[Status X])

However, when displaying this measure over the Time dimension (month), the tickets are grouped by month based on the “Issue resolved” date. I would like to group them based on the “Issue created” date.

Could someone shed a light on how to get this done? Thanks!

2

Hi @dverlinden,

Issue change history measures represent data on the timeline by the change date.
The measure “Days in transition status” is shown in the Time dimension for the date when the issue transitioned FROM (moved out) the transition status. Please see the measure description in the documentation: Import issue change history

If you want to show aggregated time in transition status by issue creation date, you can create a calculated measure to change measures and TIme dimensions default relations.
For the calculation, use functions Filter() and Descendants() to filter issues that were created in the selected period. Then, sum up Days in transition status, ignoring the date when the transition happened.

Sum(
  --set of issues
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    --check if issue was created in selected period
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
  ),
  --sum up all days in status X ignoring the date when issue exited the status
  ([Measures].[Days in transition status], 
  [Transition Status].[Status X],
  [Time].CurrentHierarchy.DefaultMember)
)

Set measure Formatting to Decimal.
More details on calcauted measures and used functions are described in the documentation: Calculated measures.

Best,
Zane / support@eazyBI.com

3

Dear @zane.baranovska

Works like a charm, thank you very much for the help! I think I understand the syntax of measures a little better now too, so thanks for that as well :wink:

Have a nice day,
Dries

1 Like