The problem I have is that this report is including tickets created from the start of time. I’d like to only include tickets with Jira Ticket Create Date in the month of Feb 2022. When I look at the source, I see tickets created in Jan 2022, for instance.
Adding a JQL filter is not a good option as it would affect other reports. I tried to create a custom measure but not able to figure it out. What is the best way to solve this? Thank you.
Yes, the Avg days in transition status is a time-related measure and gives the result of issues that transitioned out of the state in the period, no matter when they were created (Import issue change history).
A calculation I would suggest is to SumDays in transition statusFiltering issues created in the period and divide it with Sum of Transitions from status for the same set of issues:
Note that in the calculation, we are ignoring the Time dimension ([Time].CurrentHierarchy.DefaultMember) in the Days in transition status and Transitions from status. In this way, we filter issues created in the period but look at how much time they spent in the statuses on average over all time, not only during the selected period.
This doesn’t seem to work for me, though very likely this has to do with my calculated measures.
Goal: to sort out the filter correctly, I want to do a basic count of issues created after the 13th of October, relying on this filter - when I’m sure the filter works, this calculated measure will be extended with some other calculations (this works already without a filter on creation date).
When using the filter described below, the execution of the calculated measures always returns 0 / Empty:
I would suggest a more straightforward formula without aggregating Time members but using the DateBetween function directly in the measure.
Please try the following (make sure that formatting is set to Numeric as by default eazyBI might wish to format the result as date):
[Measures].[Issue created date],
'13 Oct 2022',