Define new measurement based on total count of specific dimensions

Questions & Answers
1

Hi,
I am a newbie here so apologies if my question was already answered in another topic as I could not find the exact need.

I have 8 stages ( Testing, security scan…) in Epic with statuses ( None, In Progress, Completed).
Each is different dimension.
I want to show the count in a new field which will tell me how many completed stages I have in each Issue.
Ideally later on I want to measure the maturity of an Epic according to that but that’s another topic.

2

ok , I was able to do it -
(
[Measures].[Issues created],
[Testing].[Completed]
)
+
(
[Measures].[Issues created],
[Security Scan].[Completed]
)
…

Please let me know if there is a better way to do it.

3

Hi @Sharon_Neuman!

Sorry for the late reply!
This could count one issue twice, e.g., if an issue has Completed Testing and Completed Security Scan, this measure will give a 2. But as I understand, you are looking to count the Completed stages and in that case, I can assure you that the approach that you have found is the best way to count completed stages.

Lauma / support@eazybi.com

4

Thanks Lauma, I will use this one in my project to count the total completed stages.

1 Like