Days since issue was flagged

Questions & Answers
, ,
1

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:

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

And

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

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

image
image1044×67 2.65 KB

Any help would be greatly appreciated, cheers!

2

Hi,

Make sure you have imported “Flagged” field with value changes:
https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/jira-software-custom-fields#JiraSoftwarecustomfields-JiraSoftwarecustomfieldsimport
Only then eazyBI will import historical changes for transition field “Flagged”.

Martins / eazyBI

3

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

image
image723×327 9.98 KB

Is there anything else I can try?
Thanks again
Joe

4

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

Martins / eazyBI

5

@joejames

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:

TimestampToDate(
([Measures].[Transition to last timestamp],
[Transition Field].[Flagged],
[Time].Currenthierarchy.DefaultMember
) )

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

Martins / eazyBI