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

    Quadrant Colors using Avg Function

    Darshan Dey

      Hi,

      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: