Report that show score for every Reporter

[Davide Cascapera]

Hi Everyone,

For each request opened by users, a score is assigned. I am looking for a way to aggregate the sum of these scores for each Reporter. For example, if Marc has opened 3 requests and each of them is assigned a score of 2, and Luis has opened 4 requests and each of them is assigned a score of 3, I would like to create a graph that shows me the following:
Marc: 6
Luis: 12

[Trudy Claspill]

Hello @Davide Cascapera 

I concur with @Evgenii . There is not a native Jira dashboard gadget that can sum a custom number field. There are several third party apps that provide those types of gadgets. I found references to Community posts that provide recommendations on such gadgets using a Google search for jira cloud dashboard gadget to sum number field per reporter

If you want an intermediate an Automation Rule could be created, as suggested by @Evgenii that could post the collated information into, for example, a "reporting" work item's Description. You could then reference and/or share that information as needed.

[Evgenii]

Hi, @Davide Cascapera 

Not sure this can be done with a built-in gadget or board, but I'd suggest using Jira Automation to retrieve issues by reporter and perform calculations - for example, counting issues or summing values of some custom field.
Alternatively, the Structure app is a powerful option, as it allows you to group issues by reporter and use formulas in reports for more advanced metrics.

[Davide Cascapera]

Hi @Evgenii ,

Thanks for your answer, the issue is that, to make this report using the native JSM Function, I have to create a ghost project, where I'll create a ticket for every single report and put there the total score, summing the values from the "production" project. Its something that I can do easily, but its not to beautiful...

[Evgenii]

Hi, @Davide Cascapera 

Yes, that's exactly the problem. Jira doesn't have native functionality for that. 
That's why you need to use such ugly workarounds, or use third-party apps, like Structure with their formulas, Rich Filters with their smart gadgets, or Great Gadgets, suggested by @Danut M _StonikByte_ .
The only problem with them is, that they are paid :) But if it's not a question, you can select any suitable for your needs.

[Danut M _StonikByte_]

Hi @Davide Cascapera,

I’m afraid Jira does not offer such a report or gadget out of the box. A possible solution would be to look for an app on the Atlassian Marketplace.

If you would like to try an app, our Great Gadgets app provides a Pivot Table & Pivot Chart gadget that allows you to create this type of report with just a few clicks. The result can be displayed as a table, a heatmap table, or various chart formats.

To achieve this, you simply need to configure the gadget as follows:

In you have any questions about this gadget, feel free to contact us at support@stonikbyte.com.

Danut  

[Davide Cascapera]

Hi @Danut M _StonikByte_ 

thanks for your answer! I will try it your plugin if I can cover all the requirements. I have one question more can be used also for Asset?

Maybe we can schedule a call to make a short demo?

Thanks in advance

Davide

[Danut M _StonikByte_]

Hi @Davide Cascapera,

The Pivot Table & Pivot Chart gadget also supports custom fields of type Asset.

We’d be happy to assist you.  Feel free to contact our support team at support@stonikbyte.com if you have any questions or would like to schedule a demo.

Danut

[Eduardo Anflor - MindPro]

Hi, @Davide Cascapera 

I am not sure you can meet exactly these requirements with Jira's out-of-the-box functionalities. If you are open to a marketplace solution, I recommend Mindpro Insights. I work at Mindpro, and I believe the app can help with this scenario.

It allows anyone to create and share dashboards with dynamic gadgets easily. It means when you click on a chart segment, the entire dashboard adapts to the filter. You can choose from over 50+ available.

There are also custom gadgets that you can configure as needed. Some of them offer the option of crossing two different fields in stacked bar, line, or table format and you can aggregate values and sum them. Using your request, I tried to create a chart showing the Reporters, Issue types, and aggregate the data by sum, using a Score field created. This is what it looks like:

The gadget is simple to configure, as you can see here:

I hope that helps.

Regards,

Eduardo