Help with calculated measure based on JQL, help!

Questions & Answers
1

Hi !

How can I create a calculated measure based on this query , I try several times, but I failed :
“Cycle de vie” = Validation OR (“Cycle de vie” = Production AND Sévérité in (“Majeure”, “Mineure”))

2

Hi, @LadZ

Welcom to the eazyBI community.

I hear you on this one.
Please consider creating a calculated member in the Sévérité dimension using Aggregate to get “Majeure”, “Mineure” together. Read more here: Aggregate
The Documentation link I shared has an example of Priority.

Then use a tuple (read more here: Tuple) to create the measure:

([Measures].[Issues created],
[Cycle de vie].[Validation])
+
([Measures].[Issues created],
[Cycle de vie].[Production],
[Sévérité].<<calculated member>>>)

Please use autocomplete to make sure all the dimension names and members are correct.

Kindly,
Ilze

1 Like
3

Thank you for your feedback! it works perfectly!
Indeed, I discover the notion of “tupple”. Thanks for the links too !

Thanks again for all!