Epic number, today and date of status in progress > several months

Questions & Answers
, ,
1

I want to calculate the number of epics whose difference between the date of transition to “in progress” status and Today is > 4 months.

I want to display the number per month in a histogram.

here is what I did:

  • A: calculated the difference between the date of transition to “in progress” status and Today: DateDiffDays(
    [Measures].[Issue Actual date of passage to inprogress],
    Now())

  • B: CASE WHEN
    [Measures].[A]>120 THEN
    [Measurements].[Issues history]
    END

But in table view, I don’t show measure B only with Issue. When I replace Issue with Time, no data is displayed.

Need help please.

2

Hi @Nanangoran

Could you elaborate a bit more on this?

You would like to count the number of “long progress” Epics per month, right?
For example, for this month, the calculation would be something along the lines as you wrote the “A” formula.
But what would you expect to return for July?
The number of issues that were “In progress” for 4 months by calculating the DateDiffDays between the updated date and the beginning/end of July?
And what if the issue was 6 months in progress but was updated in August? Where would you expect to see this issue counted?

Thanks!
Looking forward to developing a solution!
Nauris / eazyBI support