1 of 1 people found this helpful
Try this on your variance average calculation. I was able to get the results you wanted.
WINDOW_AVG(SUM([2015 Value])/SUM([2014 Value]))/COUNTD(Region)
Thank you, Guillermo! I struggled to make that work in my actual workbook for some reason... I ended up going the route of adding the Region to the row shelf, then hiding all but 1 region, then I hid the region header. Appreciate you taking a look at it! Thank you Thank you!
Instead of using the COUNTD(Region) to keep it dynamic, set that value manually. So for your example you can do this: WINDOW_AVG(SUM([2015 Value])/SUM([2014 Value]))/2 where 2 is the number of regions in your viz. Or set that 2 to be a parameter to be customizable if needed in case the number of regions change.
For this scenario I think I prefer it to be dynamic. But for other scenarios what you suggest could be a great solution. Thanks for the feedback! Appreciate it.