I didn't check the numbers carefully,
but I think it will work if you adjust your settings on the Dashboard Filter Action
to only have Sheet 4 as a the target.
Please see workbook attached in the Forum Thread.
270593map.twbx 83.7 KB
Reply above is accurate - just need to adjust your dashboard filter and you should be all set! To further help and add a signifier to the end user, you could look to add a label once you filter:
IF WINDOW_MAX(COUNTD([State])) = 1 THEN MIN([State])
Best of luck!
Example.twbx 84.4 KB
This worked great, Thank you so much!
sorry to piggie back on this ( it was of great help to me), but how did you remove the @openstreetmap contributors note on the bottom of the 2 state?
Not sure what note you're referring to--i didn't have any notes on mine.
In Carly's workbook, in Map > Map Layers,
the washout was set to 100% which got prevented the tag from showing up:
Please see Kettan's reponse in middle of the page.