I am using Jira and Rich Filters, and Rich Gadgets. I have to create a bar chart showing the year's four quarters. Each quarter contains the issues due that quarter and accumulates the story points. The team has seven members. Here is the challenge for me.
I need to accumulate the total story points for all seven members for a quarter and then divide the total by seven to obtain an average and not a sum.
I am using a Rich Filter Data Bar Chart and have written the Rich filter. The bars on the chart show the sum of the quarter's story points, not the average. Is there a way to divide the sum by seven to get the average for the team and use that value for the bar?
Has anyone else solved this or knows a way to allow me to show the average and not the sum?
Thank you so much for your help!
