Velg en organisasjon
Conditionally Color Data Based On The Result Of The Trend Line
Publiseringsdato: Apr 30, 2025
Oppgave
How to conditionally color the marks based on the trend line?
e.g. color the points above the trend line.
Trinn
2. Create a calculation field Trend line, based on the equation above.
58.5669*sum([Quantity])+99.74123. Create a calculation field Above Trend line?
SUM([Sales])>[Trend line]4. Add Above Trend line? to Color, now the color of the plots will be separated in 2, but there will be 2 trend lines
5. Right click one of the trend lines and select Edit Trend Lines...
6. Uncheck the following factor AGG(Above Trend line?) from the Options
7. Change the color of Above Trend line?
Flere ressurser
Allow values of a trend line to be captured and used in calculations / further c
Knowledge-artikkelnummer
001456695
Hjalp denne artikkelen med å løse problemet ditt?
La oss få vite det slik at vi kan forbedre!
