I have a measure WO Count (Work Order Count). I need to get the avg of the WO Count. I used the inbuilt measure AVG to do it, but the value is 1 for all the rows. Can anyone have idea abt this?
Also I want to do Sum of all the AVGs. When I tried, tableau shows the avg of the grandtotal istead of summing up the avg values individually.
Pls help me with the above query.
Please follow the below link which clearly describes the behavior of Grand totals and how to customize them.
Hope this helps!!!