7 Replies Latest reply on Apr 19, 2018 6:59 AM by Darshan Dey

    Quadrant Colors using Avg Function

    Darshan Dey


      I am trying to color the points based on their Quadrant based on the Avg of X-Axis & Avg of Y-Axix.


      Currently Im getting the colors but the problem is Tableau is considering entire data and giving the Avg of Y-Axix, I want Avg of the data which is present after putting some filter.  


      Can we use WINDOWS_AVG here?


      Screenshot for Reference:


      1. Output:



      2. Color Position Formula which im currently using:


      3. Average of X & Y Axis Formula: