Comparing output of 3 reports in one page

[Pat]

Team,

I have created total 3 queries:

1. Number of issues created in project 1

2. How many of them got changed to a specific status (Example: In Engineering")

3. How many of them got a child Project created within the actual project (Basically haslink option)

Now I need to create a report which will show % difference between these 3 output.

example:

output of 1 is 10

Output of 2 is 6 

Output of 3 is 2.

I need to put all the 3 into one page and see the % difference. Is this possible?

[sukkeong]

I don't think you can do it directly in JIRA.

You might need to use a webpage that queries JIRA with te JQL defined, then perform the necessary calculation and visualise

[Pat]

You mean we can do it in confluence? 

[sukkeong]

I mean to develop an external webapp that can perform query to JIRA and then perform metrics that is required. What balance of frontend-backend (client-server) would depend on the needs of the solution.

Confluence is meant for knowledge sharing rather than metrics or business analytics you need.

Side note

Alternatively, some may propose writing a JIRA plugin to perform these metrics/analytics. However, I think this has a few downsides

• tie-in to JIRA and its version's API
• unable to adapt between JIRA server, JIRA dataserver, and JIRA cloud
• slow to scale or update business rules; as a plugin, code needs to be changed, tested and deployed. With independent service, you just change your rules and refresh, without impact to JIRA.