Sum of customfield value of issues grouped by dimensions

Questions & Answers
1

Hi,
I would like to create a graph by time of calculated formula.

for a specific fixVersion, for every dates group (week/month), I would like to sum a customfield value:

![EazyBi%20quesion|667x500](upload://nnaYiqV4XQ7noNQXK7B6BH5AbJR.jpeg)

image
image1410×1056 180 KB

I tried to use 2 dim table, date, issues-epics
and 3 dim table fixVersion,date,issues-epics

but failed to get sub-totals by date and fixVersion

Thanks,
Oded

2

Hi @odedmo
Welcome to the eazyBI community!

You may want to import custom field “T-Shirt Size X Status Factor” as a measure. In the result, you will get a set of measures in eazyBI: T-Shirt Size X Status Factor created, T-Shirt Size X Status Factor resolved, etc
Read more about importing numeric values as measures: https://docs.eazybi.com/display/EAZYBIJIRA/Custom+Fields#CustomFields-Totalsofcustomnumberfields

In the report, use measure “T-Shirt Size X Status Factor created” instead of the property “Issue T-Shirt Size X Status Factor” - it will sum up the value to the project level automatically, and the value will be calculated accordingly to the selected Page filter.

Also, you may want to watch a short video about measures and properties and how they differ: https://docs.eazybi.com/display/EAZYBIJIRA/Measures+and+dimensions

Best,
Ilze, support@eazybi.com