Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

[EazyBI] How to add filter that only closed ticket be able to be aggregated?

Michael Angelo Timoteo May 22, 2018

On our tickets in Jira, there is a custom field called "Amount" and now I created a report wherein on the row is the issue type and the column is the [Measure].[Amount] and Time.

 

what my report looks like is this: 

ss.PNGBut my problem here is that I am able to get the amount base on the Created date, what I want is to get the amount base on the Resolve that and there is a huge discrepancy on the aggregate of Resolve, Oploss and Retired. 

 

Currently here is my code: I use to everyone and I needed a way to add a filter that I needed only the [Measure].[Issues closed] to be incorporated in the aggregate function

Aggregate({
Filter([Issue].[Issue].Members,
[Measures].[Issues closed])
and
([Resolution Reason].[(none)], [Measures].[Last Balance created]),
([Resolution Reason].[Need To Refund], [Measures].[Last Balance created]),
([Resolution Reason].[Need To Clear Balance], [Measures].[Last Balance created])
})

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events