Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis - average of an average

    Hi everyone,

Please could you help

=

sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"} >}[AB1_ADMIT_LoS])/sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"},[place1 NAME]={"AB1"}>}Admissions)

This is calculating the average time spent in place1 during that week ending.

Now I need to plot the Average expression in my chart.  How would I use this average by weekending to aggregate an average expression?
I am new and I am not too clever at writing set analysis just yet.

Thank you in advance.

1 Reply
Jacek
Educator-Ambassador
Educator-Ambassador

Hi Sarah

Can You attach some data? What means [AB1_ADMIT_LoS] and Admissions column? Did You try use AVG function?


TIP: average of averages = sum values of averages / count of averages