I need help with Dynamic calculate average on an AGG field called "SPI" which is a calculated field of sum(COMP_Hours)/sum(CLOCK_Hours) after couple filters applied on a dashboard. Any combination of these filters can be applied. BT, Budget, Employee, Shift, Date, weektype and one parameter. I tried WINDOW_AVG and add to context but it didn't work. I thought of LOD but don't know much about it.
Appreciate for the help. Thanks
#Tableau Desktop & Web Authoring
5 answers
Thanks for taking your time to help. In your example, I am expecting the average to be 12.7%. Which is the average of the 9 data point of profit ratio. What I am trying to achieve is the get the average of all the data point after the AGG calculation and whatever filters are applied.
