How do you change the date range for the pie chart gadget?

[Chris Rhodes]

I am creating a dashboard and I want to use the pie chart gadget with Assignee as the statistic type.  It shows data since installation and I would like it to be the previous 90 days.

Thanks

Chris

[Valeriia_Havrylenko_SaaSJet]

Hi @Chris Rhodes ,

As @Sushant Verma  has said, I don't think this is possible with the built-in pie chart gadget. However, this is one of the exact use cases we had in mind when developing Time in Status 

You can set date range for the pie chart gadget when you are configuring Assignee report. Just trim data for selected period (90 days). 

Another way can be by JQL 
project = [project name ] AND created >= startOfDay(-90d)

After this you can enjoy your report :) 

Add-on has 30-day free trial, free up to the 10 users and developed by my team. 

I hope you find this helpful 🚀 

[Gizem Gökçe _OBSS_]

Hello @Chris Rhodes ,

Welcome to the community. 

As Sushant mentioned the built-in Pie Chart gadget does not provide a direct option to change the date range. However, it is possible to achieve this by using a third party app. For this purpose I can recommend Timepiece (formerly Time in Status) app, the oldest and leading Time in Status app in Atlassian Marketplace, which is built by my team at OBSS. 

By using our Timepiece gadget on your dashboard, you can get your data. The best part is that you don't need any JQL knowledge.

Just select your project from the list(1), select any filed count report type and set the field as Assignee. Select Sum as the data type(2). Finally, you can select issues created in the last 90 days from the Dates section (3) and you are ready to go! (Please refer to the screenshot below for a visualization of the steps)

Your pie chart will look like this. The pie chart can show you either the percentages or the exact counts. It is completely customizable and up to you.

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Visit Timepiece (formerly Time in Status) to explore and enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Marita Norvele]

Hi @Chris Rhodes

If you are willing to explore charts in eazyBI, we invite you to check out our Demo accounts: https://docs.eazybi.com/eazybi/learn-more/demo-accounts

Here is an example of a Pie chart using a Time dimension: https://eazybi.com/accounts/1000/cubes/Issues/reports/50399-issue-resolution-intervals-lead-time

This chart is saved with a default selection "All times", but you can open the menu & see all the other available options. Furthermore, you can also create your custom Time member and use it for reporting.

If you have more questions, do not hesitate to reach out to us at support@eazybi.com

Best,
Marita // support@eazybi.com

[Sushant Verma]

Hi @Chris Rhodes 

Welcome to the community!

Unfortunately, in Jira, the built-in Pie Chart gadget does not provide a direct option to change the date range. It typically shows data from the beginning of the project or installation.

However, there are a couple of workarounds you can try to display the pie chart with data for the previous 90 days:

1. Use a filter: Create a Jira filter that includes the criteria you want to display in the pie chart, limited to the previous 90 days. Once the filter is created, you can use the filter results as the data source for the Pie Chart gadget. This way, the gadget will display data based on the filter's date range.

2. Use a third-party app: There are several third-party apps available on the Atlassian Marketplace that offer enhanced reporting and charting features for Jira. Some of these apps allow you to customize the date range for gadgets like pie charts. Consider exploring apps like EazyBI, Better Excel Exporter, or Advanced Roadmaps, which provide more advanced reporting capabilities.

Regards,
Sushant Verma