Get a count of a particular issue type that's older than 10 days

Questions & Answers
1

Hi, I’m trying to bring the average age of a certain issue type down and would like to see how many issues exist in Jira for that issuetype that are older than 10 days. Can someone help me with the syntax for creating a user defined calculated member for this?

2

I have used solution, found somewhere here, and it works for me.
You use DateDiffWorkDays to count days between some dates, and those dates you can get for example from status transition or by some expressions like Now(). My cases:

calculated member formula

DateDiffWorkDays(

       (
       [Measures].[Transition to status first date],
       [Transition Status].[During development],
       [Time].CurrentHierarchy.DefaultMember
       )
  ,
  Now()
)

another example:

DateDiffWorkDays(
       (
       [Measures].[Transition to status first date],
       [Transition Status].[During development],
       [Time].CurrentHierarchy.DefaultMember
       )
  ,
       (
       [Measures].[Transition to status last date],
       [Transition Status].[Waiting for PRD deploy],
       [Time].CurrentHierarchy.DefaultMember
       )
)

Here you can start…

3

Hi @faiyaz.ally ,
To track issues that are more than ten days old, you can benefit from the Age interval dimension: Interval dimensions

You can also specify an interval with from -to range and with an optional /step . For example, 0-100/10:

image
image1184×612 42.8 KB

will create intervals below (some are empty as I don’t have any issues in those intervals). Use the measure “Issues due” in your report to see unresolved issues:

image
image1530×872 77.9 KB

:warning: Note that the age intervals are applied to all eazyBI account reports!

Best,
Gerda // support@eazybi.com