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

Chris Rhodes
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 2, 2024

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

4 answers

3 votes
Gizem Gökçe _OBSS_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 15, 2024

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)

Assignee Duration Gadget 1.png

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.

Assignee Duration Gadget 2.png

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

3 votes
Valeriia_Havrylenko_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 12, 2024

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)

Знімок екрана 2024-05-12 о 19.41.30.png

 

 

 

After this you can enjoy your report :) 

Знімок екрана 2024-05-16 о 22.22.50.png

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

I hope you find this helpful 🚀 

0 votes
Marita Norvele
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 10, 2024

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

0 votes
Sushant Verma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 2, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events