How to display status from multiple project in dashboard

[Harvinder kaur]

I am trying to create two dimensional dashboard to show progress for all the projects based on their status. I have filter which is selecting all projects and checking the status. I am getting the data but it is duplicating the column name for each project instead of showing all in one column. for ex. it is repeating TO DO column 4 times for my 4 projects. Is there any workaround? Appreciate any help.

Thanks

HK

[Bill Sheboy]

Hi @Harvinder kaur 

As others have posted, this symptom is an unfortunate consequence of the design choices for team-managed projects.  Here is one of the many suggestions (i.e., defects) for that symptom: https://jira.atlassian.com/browse/JRACLOUD-72282

A couple of workarounds for this both have "costs":

• cost: more money spent on addons
  • investigate marketplace dashboard gadgets which can gather the issues based on the status name, rather than the status id value
• cost: more complexity, risk, and usage of automation executions
  • add a global (i.e., company-managed) single-select option field which parallels the values for your status names
  • add the custom field to each of the team-managed projects
  • add automation rules, triggered on issue transition, which set the custom field
  • use that custom field on the dashboard gadgets

I recommend watching that improvement suggestion and looking to the marketplace for an addon, rather than implementing the automation rules.

Kind regards,
Bill

[Harvinder kaur]

Thank you Bill, I did check that defect. Hopefully soon they will come up with the solution, for time being I am adding all project separately in one dashboard. Each one is showing its own statuses. 

[Marlene Kegel - codefortynine]

Hello @Harvinder kaur,

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

Our app provides a wide range of dashboard gadgets, and matches statuses by name not by ID. This means, if the statuses have the same spelling, our app treats them as the same, no matter in which project they are located.

I the Pie Chart and Bar Chart gadgets you can also use custom JQL values.

You can check out Quick Filters for Jira Dashboards without installation on our demo dashboards.

[Danut M _StonikByte_]

Hi @Harvinder kaur,

Try the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app. It can display multi-dimensional statistics for you by various criteria like issue count, sum of story points, or percentages.

Specifically for your need, this can be done with a few clicks. Projects completion can be displayed in various ways:

Table

Heat-map Table 

Chart - you can choose from various chart types. In this case I recommend the multi-pie chart

More examples about this gadget (and the many others offered by the same app) in these articles:

• https://community.atlassian.com/t5/Jira-articles/Building-a-powerful-Kanban-dashboard-in-Jira-with-Great-Gadgets/ba-p/1664331
• https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

You could start with 1 month free trial. If you need any help, feel free to contact support@stonikbyte.com at any time. 

Hope this helps.

Danut.

[Rebekka Heilmann (viadee)]

Hi @Harvinder kaur 

are you sure, that these projects have indeed the same status? Might be multiple Objects with the same name. Does the filter contain Team Managed projects?

If all is in order with the data, setting it to Filter Result and showing Status per Project should do exactly what you'd expect it to do and wouldn't duplicate any Statuses.

[Harvinder kaur]

yes, I have filter like this

project in (ABC, DEF) and Status in (TO Do, TESTING)

so my result is showing 3 times TO Do and testing column like one for each project

[Rilwan Ahmed]

Hi @Harvinder kaur ,

Seems you have similar status names configured in your project. Go to admin settings --> Issues --> Statuses and check if there are multiple "TO DO" Status displayed.

(direct url: https://<baseurl>.atlassian.net/secure/admin/ViewStatuses.jspa )

Also please share the screenshot from your gadget and its configuration. 

[Harvinder kaur]

Yes each project has it's own statuses which are similar. So can't I have one column for TO Do and i get data from all the projects/To do task in that one column. So basically it is showing To Do column for all the projects.

[Rebekka Heilmann (viadee)]

@Harvinder kaur instead of showing Status you could show Status Category (To Do, In Progress, Done).

[Harvinder kaur]

Status Category is not available in Two dimensional jira dashboard