1 of 1 people found this helpful
The simplest way to do this would probably be to create multiple sheets, then place them all on a dashboard. I'd start by adding a new field to the spreadsheet that has an ID or name of your chart. See below that I have a new Chart column, which has values 1 and 2.
Then, in Tableau, when you connect to the new data set, it will include both and will go a bit haywire.
Add Chart as a filter and select the value, "1". Then right-click the filter and add it to context. You'll now have this:
Duplicate this sheet then change the filter to 2.
You can then add them both to the dashboard.
Of course, you'll need to do that for each of your charts.
Right-click the filter and add it to context.
The template uses fixed LOD calculations, so it's really important to consider the Tableau Order of Operations. By adding this to context, we're telling Tableau to apply the filter first, before calculating the LOD.
I'd suggest reading through the following: Tableau's Order of Operations - Tableau