The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

How can i calculate a date difference with a measure date field and now

Álvaro Galvez Garrido
March 25, 2021

I'm trying to calculate an average time of an open issue report with the function DateDiff but when I put the arguments it shows a empty field.

I know the measure info compiles dates and other information so:

How can i calculate it in this case?Screenshot_1.jpgScreenshot_2.jpg

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Mariana_Pryshliak_Saasjet
Atlassian Partner
March 28, 2021

Hello @Álvaro Galvez Garrido 

You can try a Time in Status for Jira Cloud developed by my team. It generates 7 types of time reports, including the Average time report, which shows the average time issues spent in statuses during a specific period of time.

averagetime.png

Also, you can export reports as XLSX or CSV files for further analysis.

Hope it helps

Best regards, Mariana