Question
How To Add Trend Line with String Dimension
Before
After
Last Modified Date: 18 Feb 2021
Environment
- Tableau Desktop
Answer
1. Create calculation field [Order] using RANK to define how you want to sort [Category]ex: sort by Data source order
RANK(ATTR([Category]),'asc')
2. Drag [Category] from [Columns] to [Detail]
3. Drag [Order] to [Columns]
4. Right click on [Order] -> [Compute Using] -> [Category]
5. Create calculation field [Label]
AVG(-1)
6. Drag [Label] to [Rows]
7. Remove all fields in [Label] Marks card
8. Drag [Category] to [Label] in [Label] Marks card
9. Change mark type to [Text] in [Label] Marks card
10. Right click on [Label] in [Rows] -> [Dual Axis]
11. Right click on [Label] axis -> [Synchronize Axis]
12. Right click on [Label] axis -> [Show header] to hide header13. Remove [Measure Names] from Marks card
14. Adjust [Size] of [Sales]
15. Right click on [Order] axis -> [Show header] to hide header
16. Drag [Trend Line] from [Analytics] to SUM([Sales])
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