Question
How can we filter a bump chart by the top N of the most recent data?
Last Modified Date: 22 Sep 2023
Environment
- Tableau Desktop
Answer
The steps listed below can be reviewed in the sample packaged workbook located in the Attachments section of this article.1. Create a bump chart referring to this article.
2. Create a parameter as follows and name it Top N.
3. Right-click Top N parameter and select Show Parameter.
4. Right-click Sub-Category in the Data pane, and select Create > Set.
5. Open Top tab and configure as follows.
Below is a sample formula.
SUM(IF DATETRUNC('year',[Order Date])= {FIXED :MAX(DATETRUNC('year',[Order Date]))} THEN [Sales] END)
6. Add Sub-Category Set to Filters shelf.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