Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,362,860
Community Members
 
Community Events
168
Community Groups

EazyBI - Aggregate a Measure based on a filter of Issue Type and Status

Edited

I am using eazyBI and I want to aggregate a measure based on a filtered set of data based on Issue Type and Issue Status however I cannot get it to work. My Define Calculated member is as follows

 

Aggregate(
Filter([Issue].[Issue].Members,
[Measures].[Issue type]="ACR"
AND [Status].CurrentMember.[Approved]),
[Measures].[Issue Requested Budget (USD m)])

 

The problem I have is around [Status].CurrentMember.[Approved] not behaving as I am expecting I think

 

Thanks in advance

Graeme

1 answer

0 votes

Hi @Graeme Kelly 

In this case, you could check if the field "Requested Budget (USD m)" is imported as a measure in eazyBI.

Then you could use this imported measure as a numerical value in a tuple code when creating a new calculated measure.

 

(
[Measures].[Requested Budget (USD m) created],
[Status].[Approved],
[Issue type].[ACR]
)

 

That would aggregate all the Requsted budget values for all issues in ACR type and Status Approved for your report.

 

You might also want to check different similar use-cases here:

https://community.eazybi.com/

 

Martins / eazyBI team

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events