Question
How to conditionally color the marks based on the trend line?
e.g. color 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 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?
Additional Information
To voice your support for the future implementation of a similar feature, please vote on the following idea:Allow values of a trend line to be captured and used in calculations / further c
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