Count of issues updated more than 5 days ago

Thanks in advance for any help that can be offered here. What I am trying to do is get a count of how many issues have not been updated in five days by priority.
We have several issues with multiple priorities like major, minor, etc. How would I go about getting a count of something like this?

                   Count

Critical 2
Major 5
Minor 10

Sorry about the formatting of my table. I was trying to show an example of my desired output. Essentially, I would like to get a something that says there was 2 critical issues with a last updated date of 5 days ago, 5 major issues with a last updated date of 5 days ago, and 10 minor issues with a last updated date of 5 days ago.

Hi @Michael_Arcese,

You could achieve this with a calculated measure that uses the PreviousPeriods function. It would create a set of the Time dimension Day level members that are five days and more from now. Then the Sum function would calculate the measures “Issues last updated” values for each set member and return the sum. Finally, you could subtract the “Issues resolved” measure to get the count of all open issues. Please have a look at the code below:

Sum(
  PreviousPeriods([Time].[Day].CurrentDateMember.Lag(4)),
  [Measures].[Issues last updated]
)
-
[Measures].[Issues resolved]

Kind regards,
Roberts // eazyBI support

This measure is great - thanks.

How could I make the measure a time period (i.e. now to 30 days, 31 days to 60 days, etc).

So one measure for 31 days to 60 days, and another measure for 61 days to 90 days?

Thanks

Mark

Hi @MarkWheeler,

You can either define several calculated measures with a similar construct or define a new JavaScript calculated interval dimension.

For a calculated measure, the formula could look similar to the one below:

Sum(
  {[Time].[Day].CurrentDateMember:[Time].[Day].CurrentDateMember.Lag(6)},
  [Measures].[Issues last updated]
)

It will return the number of issues updated in a seven day period (today - six days ago). See the eazyBI documentation page on calculations with Time dimension - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-time-dimension.

Several such calculated measures could negatively affect the report load time. In such a case, you may want to pursue the JavaScript calculated interval dimension option. The calculation then would be done during data import instead of report execution time. See more details on interval dimensions here - https://docs.eazybi.com/eazybijira/analyze-and-visualize/interval-dimensions.

And here is our documentation page on defining a JavaScript calculated interval dimension in the eazyBI advanced settings for issue updated age - https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Customcalculatedfieldasanintervaldimension.

Best,
Roberts // support@eazybi.com