Rich Filters - Sum Query Result Column

Question

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?

Kalyan Sattaluri_iinm1n · Answer

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

Kalyan Sattaluri_iinm1n · Answer

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)

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

John Funk · Answer

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.