Average value of calculated measure by fix version

Questions & Answers
, ,
1

Hi,

I calculated the waiting for release time for the different features that I have of my product. Different features can be released at the same time and I use the fix version dimension to track the release date.

For instance, for the fix version SP2305.01L6 I only released 1 feature 3279 with a waiting for release of 1,55 days.
But for te SP2307.01 I released 3 features with different waiting for releases. What I want in this case is to have the average of waiting for release per fix version.

For SP2305.01L6 it will be 1,55 as I only have 1 feature released, but for the SP2307,01 should be (13.29+12,67+12,67)/3

image
image1072×274 19.9 KB

I tried this formula but seems to be wrong:

image
image851×315 6.05 KB

Many thanks,

2

Hi @isabela13,

Thanks for posting your question!

You are looking in the right direction; just a small adjustment is needed to give the context for this formula:

AVG(
 Filter(
 Descendants([Issue].[Issue].Members, [Issue].[Issue]),
 [Measures].[Issue Type] = "Story"
 AND
 [Measures].[Issue Fix Versions] = [Fix Version].CurrentHierarchyMember.Name
 AND
 NOT IsEmpty([Measures].[W4R])
 ),
 CASE WHEN 
 ([Measures].[Issues created],[Time].currentHierarchy.Defaultmember) > 0
 THEN
 [Measures].[W4R]
 END
)

In this calculation, W4R value is included in the average only if there is at least one issue created. If no issues were created, the W4R value is excluded from the calculation.

I hope this helps!

Best,
Marita // support@eazybi.com

1 Like
3

Many thanks, @Marita_Norvele!

Now I want to create a line chart with the W4R per fix version value.

image
image1747×443 41.2 KB

For instance, for SP2309.01 I want to see only one dot for the value 19. I don’t want to have the IDs of my issues (VESC-3543, etc.).

Something like this built in Excel (bar chart instead of line, but same logic).

image

Is it possible considering the way that I created the formulas?

Best wishes,

4

Hi @isabela13,

If you wish only to see Fix versions in your report, you can remove the Issue dimension from your report. You might also need to remove the applied filters for W4R to see results in your report.

This should give you a report similar to the one you are showing in Excel. You can then play around with different charts if needed (to create bars, lines, etc.).

You can read more about chart creation here: Create charts and Customize chart

Best,
Marita // support@eazybi.com

5

Many thanks for your support, Marita! Wish you all the best! :smiley:

1 Like