3 Replies Latest reply on Sep 10, 2018 5:04 AM by Zhouyi Zhang

    Dynamic Scatterplot color / scatterplot axis

    Samar Samir

      So , I have been trying to specify colors for each quadrate in dynamic way and this is how I did it :

      IF AVG([Scale])> 2.5 AND SUM([Number of Records]) >  AVG([Number of Records])  THEN 'Top Right'

      elseif AVG([Scale]) > 2.5 AND SUM([Number of Records]) < AVG([Number of Records]) THEN 'Top Left'

      elseif AVG([Scale]) < 2.5 AND SUM([Number of Records]) > AVG([Number of Records]) THEN 'Bottom Right'

      elseif AVG([Scale]) < 2.5 AND SUM([Number of Records]) < AVG([Number of Records]) THEN 'Bottom Left'

      ELSE 'OTHER'

      END

       

      That did not show me all quadrates except first two due to wrong number of records.

      When I Tried to use FIXED function before the AVG number of records

      ERROR MESSAGE COMES:

      Cant mix aggregate and non-aggregate comparison or result in IF expression.

       

       

      ANY SUGGESTIONS?/??