Workdays in transition Status - Time Dimension

[AntonBDR]

Hi there,
I can create a report showing the workdays in transition status, but when I add the time dimension in order to select only recent tickets (say last three Months) the results are showing also older tickets.

How can I fix this? Is there a workaround?
Thanks

[zane.baranovska]

Hi @AntonBDR,

Each measure is related to the Time dimension differently. For example, the measure “Issues created” shows the issue count on the timeline by issue creation date (as the measure name suggests). But measure “Workdays in transition status” shows duration in transition status by the transition date - when the issue moved from one status to another.

More details on what historical measures like transition counts and duration in transition statuses represent and how those are related to Time dimension are described here: Import issue change history

If you want to change the default behavior of measure “Workdays in transition status” and filter reports by creation date (using the Time dimension), you can create a new calculated measure (Calculated measures).

Please see those two Community posts on similar use cases and examples for the calculated measure:

Filter report based on Jira Ticket Created Date

Hi @Rahul_Aurora, 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 Sum Days in transition status Filtering issues created in the period and divide it with Sum of Transitions from status for the same set of issues: Sum( Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]), DateInPeriod([Iss…

Measure pickup time

When you want to compare two events on dates (created date and first status change), you would like to use Issue level calculations with MDX formulas. Here is an example formula for it: Avg( Filter( Descendants([Issue].CurrentMember,[Issue].[Issue]), -- filter by issue properties, in this case Issue creation date DateInPeriod( [Measures].[Issue created date], [Time].CurrentHierarchyMember ) ), CASE WHEN -- filter with measure to pick issues based on dimension usa…

Best,
Zane / support@eazyBI.com