Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can i calculate different date of transition status of two status?

amiriamiri
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 6, 2017

DateDiffDays(
CASE WHEN [Transition Status].[To Do] > 0 then
TimestampToDate(
[Measures].[Transition to status last timestamp]
),CASE WHEN [Transition Status].[Done] > 0 then
TimestampToDate(
[Measures].[Transition to status last timestamp]
))

I try another query but not work

DateDiffDays(([Measures].[Transition to status last date],[Transition Status].[To Do]),
([Measures].[Transition to status last date],[Transition Status].[Done]))

0 answers

Suggest an answer

Log in or Sign up to answer