The 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

1. Create a dashboard and add the Two Dimensional Filter Statistics gadget.
2. Use a filter that returns for all projects.
3. 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.

[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

[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

[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.

[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.

[Marc - Devoteam]

Hi @Chandrashekhar Kavi 

Check the reply from @Bill Sheboy

This is due to the project types Jira offers. If you use team and company managed projects in your instance, this will keep visble.

This is a bug.

If you want to have consistency, make sure the project you want to include in the filter are all team managed or company managed projects.

See documentation on project types in Cloud.

[Chandrashekhar Kavi]

Hi Marc, I have already checked for all my projects are running under team-managed.

[Marc - Devoteam]

Hi @Chandrashekhar Kavi 

That's the issue that is referred by @Bill Sheboy

Team managed projects are single containers for each project.

To mitigate your issue, you need to create 4 new Company Managed projects, and move the issues from your Team Managed projects to the relevant new projects and create a new filter and base your gadget on this.

Or you could choose to get a reporting app from the marketplace, based on suggestions from @Bill Sheboy 

[Chandrashekhar Kavi]

Please refer the above image, it's showing okay for all the other projects excluding only 1 for status = "DO LATER", as I told you before, I have checked project type and also checked status name, status category for all the issue types.

[Marc - Devoteam]

Hi @Chandrashekhar Kavi ,

Status could been written in lower cas, this will not show on the workflow, or contains a trailing or leading space.

I would urge you to move to company managed projects, as any admin on a team managed project is able to change the workflow.

When using company managed projects the workflow can be shard on projects, so you only have to maintain 1 workflow and not 8.

[Chandrashekhar Kavi]

I have checked all the values (which I have made red rectangle) for all the projects what was shared earlier in my today's first post.All found same, but still the same issue faced, so I asked your kind help. Now I am going to try to copy value from another project and trying with paste, if it works, I will let you know on this channel. Thanks for quick responses.

[Chandrashekhar Kavi]

I have tried copy paste, it not enables update workflow button on the top, it means that status names are same in all the projects for now, but still one project is being separated !

[Marc - Devoteam]

Hi @Chandrashekhar Kavi 

I now would reach out to Atlassian Support.

They might see a discrepancy on your instance, as all else seems fine.

[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.

[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

[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.