Pie chart gadget is showing multiple of the same statuses

[Joshua Oberlin]

I created a dashboard and a filter that selects nine or so different projects. I added a pie chart gadget to the dashboard that shows the three statuses used by each project: To Do, In Progress, and Complete. However, the pie chart is showing each of the statuses several times. So instead of To Do being in the list only once as it should, it's showing up multiple times.

I read on a few different posts that this could be because I'm using "next gen" projects, or "team managed" projects mixed in with projects that are not. I've checked each of the prjoects and they're all team managed software projects. I've tried modifying the filter but there's not much to it, as all it does is filter for the nine or so projects.

Thanks.

[Trudy Claspill]

Hello @Joshua Oberlin 

Welcome to the Atlassian Community.

Company Managed projects share the statuses that are defined at a global level. When you do such a report for multiple Company Managed projects, all issues using a given status (i.e. "To Do") are using the same underlying Status entity.

With Team Managed projects, the design is to allow each project to be independently customized. Because of this, each Status entity in each Team Managed project is unique, even when they have the same human readable name. So, if you have nine Team Managed projects in your report, and each one has a "To Do" status entity associated with some issues, then you will have nine To Do entries in the report - one for the To Do value in each Team Managed project.

[Joshua Oberlin]

I understand. Is there any way to correct this besides remaking all of the projects?

[Trudy Claspill]

Unfortunately, no. That is the core of the design/architecture for Team Managed projects.

[Bill Sheboy]

Hi @Joshua Oberlin -- Welcome to the Atlassian Community!

Yes, and...to Trudy's answer:

There are multiple open suggestions / defects for this symptom, caused by the different contexts and values for Status (and other fields) for each team-managed project:

https://jira.atlassian.com/browse/JRACLOUD-78528
https://jira.atlassian.com/browse/JRACLOUD-82394
https://jira.atlassian.com/browse/JSWCLOUD-25511
https://jira.atlassian.com/browse/JSWCLOUD-25590

I believe the only workarounds are to switch to company-managed projects or use a marketplace addon for gadgets which can consolidate the values.

Kind regards,
Bill

[Marlene Kegel - codefortynine]

Welcome to the community, @Joshua Oberlin.

I am Marlene, product manager of Quick Filters for Jira Dashboards.

Our app maps the statuses by name and not by ID, which means that if the status names are the same, it will displayed in one piece on your dashboard.

You can check out our app without installation on our demo dashboards.

[Rustem Shiriiazdanov]

Hi @Joshua Oberlin ,

Is it critical for you to report against statuses, and not status categories? 

I am asking since our application, Report Builder https://marketplace.atlassian.com/apps/1216997/report-builder-custom-scripted-reports-and-tools?hosting=cloud&tab=overview allows you to report against statuses categories, which effectively reduces the number of "statuses" you see in the report to "To Do", "In Progress", "Done".

An example of a report for "Statuses":

Compare to the report against the same data, but built categorised by "Status Category":

Hope that could help you (of course, if you consider non-OOTB solutions for your trouble).

Regards,

Rustem,

Product Owner "Report Builder"

[Danut M _StonikByte_]

Hi @Joshua Oberlin,

This is because the team-managed projects have their own statuses. In your example, a "To Do" status exists in all projects but in fact there are 3 "To Do"statuses, one in each project... This is a big limitation.

A good alternative to this pie chart would be the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app. With this gadget you can create all kind of multi-dimensional tables, heat-map tables and charts of various types (including pie charts), just like you do in Microsoft Excel, with drag & drop. And it does not duplicate the statuses!

You could start with the 1-month of free trial. If you have any questions, feel free to contact us at support@stonikbyte.com.

Hope this helps.

Danut

[Varsha Patil]

I tried this, I tried with 2 company managed projects and it worked well. The query I used was like:  project='project1' or project='project2'. I saw combined PI chart.

Will you please share the filter query used.