Sum custom field grouped by assignee

Questions & Answers
1

Hi, we need to sum a calcultad field grouped by assignee, using current month and previous month like page, but we couldn’t make it work,.

The result we find is something like this.

image
image1257×369 10.7 KB

Thanks!!

2

Hi @Fran

Do I understand correctly that “Date” and “Calculated field” both are custom fields in Jira?

Then import both as measures in eazyBI, and, after the data import, you would get a measure Calculated field with Date. Read here: https://docs.eazybi.com/eazybijira/data-import/custom-fields#CustomFields-Measureswithcustomdatefields
Use this measure to get totals of the Calculated field and, used together with Time dimension, grouped on a timeline by the custom Date.

In the report, select Current month and Previous month members from Time dimensions in columns with this measure, and Assignee dimension in row.

Best,
Ilze / support@eazybi.com

3

Hi Ilze,

thanks for your help, now works well

Regards.
Fran.

1 Like