1 2 Previous Next 18 Replies Latest reply on Mar 8, 2018 2:46 PM by Joseph Berchmans

    "Nested" Parameters and Using Sheets to Highlight Controls

    Jewel Loree

      I was working with a client who was making a viz about nursing homes that had nested parameters; one that changes what group you were looking at (staff, short stay resident, long stay resident) and one that chooses what statistics for that group you are looking at. We needed a way to direct the end user which of the parameter controls to use when, so I came up with this:

      http://public.tableausoftware.com/views/NursingHomeNational2_0/NationalStats?:embed=y&:display_count=no#1

       

      I have a sheet behind each parameter control that changes color if the corresponding parent parameter is selected. The sheet is actually a treemap with a calculation on size that just equals 1. Color is chosen by a calculated field that looks at the parameter and gives a value of either “Active” or “Inactive”.  So if you are looking at staff, the staff stats box is highlighted and if you change to short stay residents, the short stay residents box is highlighted.


      What do y'all think? Does this make the dashboard sufficiently user friendly for an end user who doesn't know what parameters are?

        1 2 Previous Next