How to Filter a Bump Chart by the Top N of the Most Recent Data

Published: 21 Sep 2023
Last Modified Date: 22 Sep 2023


How can we filter a bump chart by the top N of the most recent data?


  • Tableau Desktop


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.
 User-added image
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.
 User-added image
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

User-added image
Did this article resolve the issue?