Aggregate 3 fields

[Chazza]

I’m trying to use the aggregate function to add 3 resolution members together. The graph itself, is a stacked vertical bar chart that shows how many issues have been resolved completed and how many have been resolved by the three statuses withdrawn, rejected and duplicate. I’ve managed to aggregate two of the fields before, but could never get the third working.

The desired outcome is to have 2 sections per bar with one being the resolved completed and the other being resolved withdrawn/duplicate/rejected.

Thanks.

[roberts.cacus]

Hi @Chazza

A warm welcome to the eazyBI community.

To create a calculated member that aggregates several members, please try to use a formula similar to the one below:

Aggregate({
  [Resolution].[Withdrawn],
  [Resolution].[Rejected],
  [Resolution].[Duplicate]
})

Then you can select the Resolution dimension member “Completed” and the calculated member. Please have a look at a picture of a sample report with the Project dimension:

Also, please have a look at how the report would look in the table view:

Please read more about calculated members on the eazyBI documentation page - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members.

Kind regards,
Roberts // eazyBI support

[Chazza]

Hi @roberts.cacus,

Thank you very much, this is exactly what I was looking for!

Kind Regards,
Charlie.