Question
How to display arbitrary labels according to conditions.Example
IF SUM (Profit ) > 30000
Then indicate with 'GOOD' and green text.
IF SUM (Profit ) < 10000
Then indicate with 'BAD' and blue text.
Last Modified Date: 26 Apr 2022
Example
IF SUM (Profit ) > 30000
Then indicate with 'GOOD' and green text.
IF SUM (Profit ) < 10000
Then indicate with 'BAD' and blue text.
Environment
- Tableau Desktop
Answer
<Step 1>-Preparation-
1. Connect to Sample - Superstore
2. Drag [Category] to Columns and [Region] to Rows.
3. Drag [Profit] to table.
<Step 2>
4. Create new Calculated Field as following.
Name : GOOD_Conditions
Calculation : IF SUM([Profit]) > 30000
THEN 'GOOD'
ELSE NULL
END
5. Create new Calculated Field as following.
Name : BAD_Conditions
Calculation : IF SUM([Profit]) < 10000
THEN 'BAD'
ELSE NULL
END
6. Drag [GOOD_Conditions] and [BAD_Conditions] to Text in Mark Card.
7. Click on Text in Mark Card and do the red box below.
8. Arrange text as follows.
9. Change text color as follows > OK .
Additional Information
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
Related Links
Results 1-3 of 189