2 Replies Latest reply on Nov 1, 2018 7:07 AM by Rick Loveday

    Changing displayed column headings based on a filter selection

    Rick Loveday

      I've got a separate dashboard for each college that I am trying to consolidate into a single dashboard where the data will adjust based off of a filter. I need to have the column headings adjust based on what filter is selected.

       

      We have 7 total college units: (I also have a Parameter created with these names)

      CAAH

      CAFLS

      CBSHS

      CECAS

      CoB

      CoE

      CoS

       

      We have 7 total teams:

      UDT Team 1

      UDT Team 2

      UDT Team 3

      UDT Team 4

      UDT Team 5

      Non-UDT

      Athletics

       

      I have created Groups for the teams above as follows:

      Team1 (group) - UDT Team 1, UDT (Teams 2-5), Non-UDT, Athletics, Unassigned

      Team2 (group) - UDT Team 2, UDT (All teams except 2), Non-UDT, Athletics, Unassigned

      Team3 (group) - UDT Team 3, UDT (All teams except 3), Non-UDT, Athletics, Unassigned

      Team4 (group) - UDT Team 4, UDT (All teams except 4), Non-UDT, Athletics, Unassigned

      Team5 (group) - UDT Team 5, UDT (Teams 1-4), Non-UDT, Athletics, Unassigned

       

      Some of the teams support multiple colleges

      UDT Team 1 - CECAS

      UDT Team 2 - CoB

      UDT Team 3 - CAFLS and CoS

      UDT Team 4 - CAAH, CBSHS, and CoE

      UDT Team 5 - another area not listed, but not relevant for this discussion

       

      I am trying to be able to be able to choose a filter based on the college unit and have the column names adjust accordingly.

      So if the college unit filter is CAAH, it would display as below: (The UDT column could include totals for all UDT Teams except for Team 4 based on the group)

      (the Team4 (group) pill in the filter area is just there to remove the heading called Unassigned, which counts people who are not assigned to one of the four the displayed groups, so it's not essential to have. I just didn't remove it before taking the screenshot)

      Capture.JPG

      If the college unit filter was changed to CECAS, then it should display columns for UDT Team 1, UDT (adjust to all UDT Teams except for Team 1), Non-UDT, Athletics.

       

      I need to be able to replace the Team4 (group) pill in the columns shelf with Team1 (group) when CECAS is selected as the filter. As I mentioned, I already have the parameters for each college unit. Would the best solution to create a calculated field that would change the group based on what the Parameter was? (see below, even though it doesn't work) Or is there some other way to accomplish this?

      Capture2.JPG