Using Custom Chart Gadget to make a chart

[Charles Brooks]

I'm using a gadget called custom charts for my dashboard, and I'm trying to make a chart that will show the delta difference between created and resolved and plot the delta values, and to show on a monthly or by quarters.  It would be the average delta being plotted.  I have attached a screenshot of what I'm trying to do.  Does anyone have any suggestions on how I can do this or can this be done using some automation of some kind.

[Marc -Devoteam-]

Hi @Charles Brooks 

I expect you have the 3rd party marketplace app "Custom Charts for Jira" from Tempo installed.

I did use this app quite extensive, but I don't know if this can be calculated.

You could reach out to the apps support channel.

Or it could be that you are using a different 3rd party app, as a gadgct "custom charts" is  not an ootb solution

You could check the ootb Created vs. resolved chart, but I don't think there is a delta option in there.

[Alina Chyzh_Grandia Solutions]

The Created vs Resolved report in Report Hub (https://marketplace.atlassian.com/apps/1231654/report-hub-custom-charts-reports-timesheets-for-jira - created by our team) is designed specifically for tracking the delta between issue creation and resolution over time, and you can configure it to display data monthly or quarterly using the period switcher.

If you need more flexibility in how the delta is calculated or visualized, the Custom Chart report type gives you control over the specific metrics and chart style, though you'll want to make sure your JQL or filter is pulling the right date ranges for the averaging you need. We use both report types regularly and they handle this kind of trend analysis without needing any automation, since the calculations happen at the reporting layer based on your existing Jira data.

[Bill Sheboy]

Hi @Alina Chyzh_Grandia Solutions 

As a reminder...when recommending a marketplace vendor product, please ensure you disclose your affiliation to that vendor in your post wording, and not just in your profile name / badge. For more information, please see:

Atlassian Partners - Rules of Engagement

https://community.atlassian.com/t5/App-Central-articles/Atlassian-Partners-Rules-of-Engagement/ba-p/2899328

Kind regards,
Bill

[Alina Chyzh_Grandia Solutions]

Thank you! Edited

[Charles Brooks]

How about using automation to calculate the delta difference, then using the custom charts app to graph the data?  Also, I have three years of information, so how can I use automation to back fill all the issues in the past?

[Marc -Devoteam-]

HI @Charles Brooks 

You could do this, store the outcome in a field and use that field in custom chart.

Use a scheduled trigger to address issues from the past.

As automation has limits, make sure to have a valid JQL in the scheduled trigger to batch action on historic issues.

After all are done, adjust the JQL