Need right plugin to create report

[Prathap DL]

Hello community, 

I need to create bar chart based on Part numbers.

RC is the issue type which has part number Field where user can enter single or multiple values.(Drop down Field)

Bug is the another issue type where Bug will be linked to RC.

One Bug can link with multiple RC. But one RC can link with Single Bug.

Now i need count of Bugs which are affected by part number.

I hope below image will give more clarity on the Report

Note: Part number Field is there in RC and The connection between RC and Bug is only through Link. Now i need count of Bugs which are affected through Part number.

[Maria Barrios _Adaptavist_]

Hi @Prathap DL ,

You could do this easily with Scripted Fields in ScriptRunner for Jira Cloud if that's available to you. Scripted Fields allows you to calculate information and display it in different ways, as a table for instance, using emojis, banners, hyperlinks etc., which could help you to build a visual representation of the data.

If you wanted to build this chart in a different format outside of Jira, ScriptRunner could also assist you here by communicating with the Confluence REST API and creating it there with a Script Listener, for example, every time an issue has a new part number added to it.

I hope this helps, and feel free to reach out if you have any follow-up questions.