Days since issue was flagged

Questions & Answers
, ,
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