Average time in status" gadget in Jira Dashboard

[Natalia Cie]

Hi,
I set "Average time in status" gadget in Jira Dashboard
It seems not working correctly - for some days it shows "0 hours", for some even "280 hours"
From my rough calculations the average time should be around 1-2 days in "in progress" status.
I tried to edit the gadget for various settings and it still shows weird data.
Could someone help me and let me know what should I change to make this chart reliable?

Many Thanks
Natalia

[Tiago Comasseto]

Hi Natalia,

I think the most reliable way to check if the information is correct is checking in your database. You may take one issue as example, like in this query:

select * from customfieldvalue where CUSTOMFIELD in (select id from customfield where cfname = 'Time in Status') limit 1;

And calculate the time in status manually as described here, so you can confirm whether the value you see in the chart is correct.

Cheers