I have created a report that is looking for tickets closed last month. I am trying to add up all the time, by status, for those tickets. However, I got all the tickets closed last month but only saw the data for that time. For example, I have a ticket that was closed in December (And it shows up in the report) the way it should but it only shows the time in status for December events, there were several statuses in November that I want to see for the ticket closed in December.
Welcome to the eazyBI community!
When a specific month is selected in Pages, then by default measures are linked to the Time:
“Issues closed” will show the number of issues where issue closed date is in that month,
“Issues resolved” will show those issues where the resolution date is in that month,
“Days in transition status” will show the days where transitions from status happened in that month.
If you want to see issues that are closed in specific month and for those issues to see all days in previous statuses you can use following formula that will show days in transition statuses for all times:
([Measures].[Days in transition status], [Time].CurrentHierarchy.DefaultMember)
For example, issues closed > 0 filter limits data to issues that are closed in specific month, but user defined calculation “Days in transition status Time DefaultMember” will show all days in all previous statuses:
I hope this helps.