When Issue Type Changes Then Capture the TimeStamp

Hi Team,

I have some Stories and after somedays we changed it’s Issue type to Task.
Now I’m able to see the when and who updated the Issue type under History of issue but I want to see this in eazyBI Reports.

Hi,

You could create a new calculated measure using this formula:

Timestamptodate(([Measures].[Transition to last timestamp],
[Transition Field].[Issuetype],
[Issue Type].[Task]))

Select the correct formatting for this measure to display results as dates
It will show the last date when the author made the issue type change to Task

Then use “Transition Author” dimension and filter report by new measure as explained here:
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Orderandfilterrowsbymeasurevalues

Martins / eazyBI