Getting count( JQL1)/count(JQL2) (weekly) and showing in an gadget

[Dipu Krishnan]

Hi Team,

I have a requirement where I need to show the data in a Jira gadget weekly value count( JQL1)/count(JQL2) team wise. Will it be possible anyway?

[Mariana_Pryshliak_Saasjet]

Hello @Dipu Krishnan 

You can try a third-party add-on - Time in Status for Jira Cloud. It generates 7 types of status reports, including an Average time report, which meets your needs.

 Also, you can export data as XLSX or CSV files.

This add-on is developed by my SaaSJet team. so let me know if you have any questions.

[Dipu Krishnan]

Thank you @Mariana_Pryshliak_Saasjet . I will check the add-on.

[Bill Sheboy]

Hi @Dipu Krishnan -- Welcome to the Atlassian Community!

That is not possible with out-of-the-box features of Jira.  If you specifically need that feature, please investigate the Atlassian Marketplace for addon gadgets to help.

And also, if you describe the problem you are trying to solve, perhaps the community can suggest other alternatives to try.

Kind regards,
Bill

[Dipu Krishnan]

From one project (Production Issues) I am getting the list of issues and from another project I am getting another list of issues. Both the filters have teams in common.

I want to show team wise weekly data of count in (JQL1)/count in (JQL2).

[Bill Sheboy]

Thanks, and that appears to restate what you have already noted.

What problem does that help you solve?  For example, does this help you know something about the teams with overlapping work between the projects?