_C_State In Set:
IF [_S_State Set] THEN [State] END
_C_State To City Drill Down (action):
IF { COUNTD([_C_State In Set]) } = 1
THEN [City]
ELSE [State]
END
_C_State To City Drill Down (sheet name):
IF { COUNTD([_C_State In Set]) } = 1
THEN [State]
ELSE “All States”
END
Related Tutorials:
Tableau GIF Tutorial: Add Drill Down To Your Chart Using Set Actions
A great tutorial from Jamie Reyes on applying drill down features to scatter plots.
3 Tier Map Drill-downs with Tableau Set Actions
An advanced tutorial from Craig Dewar on creating three layer drill down maps.
8 ways to bring powerful new comparisons to viz audiences with Tableau set actions
Bethany Lyons original blog introducing the power set actions – a great place to start if you’re new to this feature.