Average time in status diagram only shows flat line

[lasrik]

Hi all,

I am using Jira 5.0.7 and installed the Jira Charting Plugin 1.8. I added the custom field "time in status" with a global context (all projects all issue types). Also I have added it to (mostly) all screens. That was 3 weeks ago.

Now when I filter for issues I always get a single zero flat line as diagram. I made sure that there are actually issues in the results that have had different statuses and also there are some which have a resolution set (of course also both at the same time).

What am I missing?

Thanks

Tobi

[PauloP · Accepted solution]

Hi Tobi

This is a known BUG. Please use the following link for further details:

https://jira.atlassian.com/browse/JRA-29214

Since JIRA already have a valid field called "[CHART] Time in Status", you should not use/create this new custom field "time in status" to properly work with Averange Time In Status gadget.

Cheers,

Paulo Renato

[lasrik]

Hmm many thanks for the hint! Are you sure this bug also applies to 5.0? The bug is only classified 5.1.1, 5.2-m01.

The problem is however that I created the field only because the chart plugin was complainig that it can't show charts because of a missing field. After googling I created the custom field.

I will try to remove it and see what it does.

[lasrik]

Ok, just for reference. After removing the custom field I had to create a new one named "[CHART] Time in status" as implied by the linked bug report.

After that all worked fine.

[EddieW]

SO I added the field, and called it "Time in Status" which as noted above broke the charts. But then I deleted it and got the "required field not found" errror. SO i created a new custom field called "[CHART] Time in status" with no search options, (tried free-text search too) and now all the charts either flat-line, or say no-data available.

NOTE: THis question says you also need to include it on screens that your issues use to make it work, https://answers.atlassian.com/questions/29452/how-do-i-get-the-average-time-in-status-chart-to-work so I included the field on all screens.

Do I need to reindex? Is there a service that populates the fields? Is all historical data gone?

[CharviD]

Did your problem get resolved? I have a similar problem.

[Joshua Uda]

We had this issue after modifying workflows. We replaced "Resolved" status with a custom status. In the transition to that status, we did not include a post function to set Resolution to Done. The gadget only shows statistics for issues that are resolved. Since none of our issues had a value in the Resolution field, the gadget trend line was flat. To fix this, we had to bulk edit all issues that were in "Accepted" status following the guidance here: https://confluence.atlassian.com/jirakb/howto-bulk-edit-resolution-321857142.html

The lines showed accurate trends after we completed this bulk edit.

[Tim Chick]

I'm running JIRA 6.2.6 and Charting Plugin 1.23 and am still getting a flat line.  I have tried creating a "[CHART} Time in Status" field and re-indexed.  Still Flat line.

[CharviD]

Hi, Did you find a solution to this problem? I have got the same problem.