Question
How to conditionally colour the marks based on the trend line?
e.g. colour the points above the trend line.
Last modified date: 05 Mar 2024
Environment
- Tableau Desktop
Answer
1. Hover the mouse over the trend line to confirm the equation.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 Colour, now the colour 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. Untick the following factor AGG(Above Trend line?) from the Options
7. Change the colour of Above Trend line?
Thank you for providing your feedback on the effectiveness of the article.
Open new case
Continue searching
Knowledge Base
Community
Product help
Training and tutorials