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:
But 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])
})
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.