using two dimensional filter statistics in jira where selecting status on xaxis and project on yaxis, jira providing result with repeating same status name on the xaxis, is there any solution? Steps to Reproduce * Create a dashboard and add the Two Dimensional Filter Statistics gadget. * Use a filter that returns for all projects. * Select the Y and X axis as Project and Status Expected Results The gadget loads the issues per status, for an only different status. Actual Results It returns all statuses, even those with the same name.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Duplicate status in Two Dimensional Filter Statistics gadget

Chandrashekhar Kavi

using two dimensional filter statistics in jira where selecting status on xaxis and project on yaxis, jira providing result with repeating same status name on the xaxis, is there any solution?

Steps to Reproduce

Create a dashboard and add the Two Dimensional Filter Statistics gadget.
Use a filter that returns for all projects.
Select the Y and X axis as Project and Status

Expected Results

The gadget loads the issues per status, for an only different status.

Actual Results

It returns all statuses, even those with the same name.

Accepted answers

Bill Sheboy

Hi @Chandrashekhar Kavi

This is a known defect, caused by the design approach used for team-managed projects, and it impacts many gadgets and features. Here is the one for that gadget, which you may watch / vote for to see progress: https://jira.atlassian.com/browse/JRACLOUD-72282

Some possible work-arounds are to:

use a marketplace addon which can summarize on the status names rather than status id
report outside of Jira to rollup the results

Kind regards,
Bill

All comments

Sanjog Sigdel

Hello @Chandrashekhar Kavi Can you please share your Filter Query?

Chandrashekhar Kavi

project in ("A","B","C","D","E","F" ) order by project

jira two dimensinal filter statistics.jpg

Marc -Devoteam-

Hi @Chandrashekhar Kavi

I have made a filter just like yours, I just left out the order clause as the sort by and direction can be set in the gadget.

Mine shows only one single status, but this is because all projects use the same WF.

You have created different types of projects team managed and company managed.

Team managed projects are containers and don't re-use any project information from other projects.

That's the reason you see duplicate done statuses.

example I made with team and company managed projects

Screenshot 2023-10-18 at 15.44.09.png

Chandrashekhar Kavi

Hi Marc, I have multiple statuses in multiple projects, you shared screen shot is showing only single status in it ! What more information I should provide you to reproduce the error?

Marc -Devoteam-

I just edited my reply, as I read your request wrong.

Bill Sheboy

Hi @Chandrashekhar Kavi

Some possible work-arounds are to:

use a marketplace addon which can summarize on the status names rather than status id
report outside of Jira to rollup the results

Kind regards,
Bill

Chandrashekhar Kavi

Hi Marc,

I've reviewed the workflows for all the available projects, and I followed the "DO LATER" status to repair and conduct testing. I completed this process for all eight of my projects, as shown in the screenshots below. However, I'm still encountering an issue with one of them though other 3 duplicates removed after correcting for the said status. Is there something else I should be checking? Your assistance would be greatly appreciated.

Thank you. jira two dimensional filter statistics do later.jpg

Obaid Alnaqbi

how can I get YAxis by Year?

in other words, can get all projects and from the date make the YAxis = year

Marc -Devoteam-

Hi @Chandrashekhar Kavi

This can only be done if you would create a custom field year and fill it with information.

This is the gadget can only use Jira fields as axis options.

Otherwise you would require an app from the marketplace on reporting that offers such functionality in its dashboard gadgets.

You could look at Custom Charts app from Tempo.

Marlene Kegel - codefortynine

Hello @Chandrashekhar Kavi,

I am Marlene from codefortynine.

Our app Quick Filters for Jira Dashboards matches statuses by name, not idea. This makes it possible to create cross-project statistics. We not only handle statuses this way, but also other fields like "components", as you can see in the screenshot below.

quick-filters-for-jira-dashboards_match-components-per-name-across-projects.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

atl-bobross