Days since issue was flagged

We have a report that tracks how long an issue has been flagged for, but it only works once that item is unflagged.
We’re looking for a way to report on how many days an issue has been flagged while it’s still marked as flagged.
I’ve tried:

([Measures].[Transition to last timestamp],
[Transition Field].[Flagged])  


    ([Measures].[Transition to last timestamp],
     [Transition Field].[Flagged])  

But neither show any data.
This is how the issue shows up as flagged in Jira if that helps:

Any help would be greatly appreciated, cheers!


Make sure you have imported “Flagged” field with value changes:
Only then eazyBI will import historical changes for transition field “Flagged”.

Martins / eazyBI

Hi Martins - thanks for your reply. Flagged is imported with value changes but neither codes above show any data.

Is there anything else I can try?
Thanks again

Perhaps there is something in your report definition.
Please export it and paste it here.

Martins / eazyBI


Just thinkging, If you use “Time” dimension in your report to filter the report it would affect the result and filter only changes within the selected time period.
Try this more universal formula:

([Measures].[Transition to last timestamp],
[Transition Field].[Flagged],
) )

And similarly, add [Time].Currenthierarchy.DefaultMember in your second formula

Martins / eazyBI