Rich Filters - Sum Query Result Column

kate reeder March 22, 2024

Hi folks - We're using a scrum board on a company-managed project in Jira software. 

Does anyone know if there's a way to sum a column of data in a rich filter query result? For example, I have fields for dev story points vs. QA story points and we're including this data as columns in our rich filter query results. I'd like to filter on sprint, and then in the query results be able to sum the QA story points vs. Dev story points to get a total story points for each team for that sprint. It would be really great if I could just get the rich filter to sum the data and include that sum in parenthesis within the header of the column. 

...if rich filters can't do this, is there a better way to get this data, maybe from some reporting that I'm just unaware of? 

3 answers

0 votes
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 23, 2024

Hello @kate reeder 

This is how I do it in our RF for Data Center, 

Assuming these points fields are numeric fields and you have created a filter, created an equivalent rich filter:

- Go to you rich filter configuration and click custom values, give a name for Label, choose "Dev points" field as your base value and Total formula as "Sum Total". Do the same for QA points field. (screenshot 1)

- Then go to views and choose these 2 fields for a view. Add  Sprint as Dynamic Filter. (screenshot 2)

With this, set up of Rich filters is done, we can go to dashboard.

- In your dashboard, choose controller & rich filter statistics gadgets, give both of them your RF name.

- In your rich filter statistics gadgets, choose statistics type as a field you want it to break it down by (Team for example) and Values as the 2 custom values you created earlier. (screenshot 3)

- This set up will give you Sprint as a dropdown in controller section, Teams as a statistic and show Dev and QA story points sum. (scerenshot 4)

 

 

image.png

 

image.png

image.png

image.png

I chose Issue Type, you can choose Project for your requirement. Hope it helps.

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 23, 2024

To clarify, Instead of "Team" choose "Project" for your gadget statistics as that field is available in statistics type..

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 23, 2024

Hi Kate,

I don't think you can get it as a column, but you should be able to add a Totals row at the bottom of the results that sum up the column.

0 votes
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 22, 2024

Hi @kate reeder 

Is this the App you're referring to? - Rich Filters for Jira Dashboards 

If yes, I'd try contacting the vendor, to see if they can assist with this directly. Their contact details are on the right-hand side of their Marketplace listing's support tab (link above).

Ste

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events