Hi all,
Appreciate any help y'all can offer.
I am creating a dashboard looking at data by legislative district. I have a parameter to select Assembly/Senate and based on that want the user to then be able to select from only Assembly or Senate districts.
This would be simple enough to do with a filter, but I don't believe it will work for the filter to apply at this point because I also need functions to select non-district comparisons. If parameters were dynamic, that would work perfectly, any workarounds?
Thanks!
The "set action" stuff coming in 2018.3 would take care of this for you.
For now, though: When you select Senate or Assembly (that would be a parameter), then you can display one of two other parameter lists: one for Senate districts, or one for Assembly districts.
Parameters limit you (for now) though, in that parameters are only single-select creatures. If you want your user to select ONLY ONE (or ALL) districts, then a parameter solution can work. You might not need separate sheets. You could probably handle it all through calcs.
2018.3 set actions would also allow multi-select lists. And yes, they would work like parameters, so we can have the functionality of multi-select parameters once we get access to that new feature!
