Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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