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
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.