2 Replies Latest reply on Apr 20, 2018 11:22 AM by jonathan kassak

    Comparison Groups, Options to enable / facilitate

    jonathan kassak

      Good morning Community

      I would welcome any suggestions/options regarding how to create or establish an ability to readily change comparison groups in my dashboard. 

      For this example, the groups I am referring to are hospital inpatient units.

       

      To illustrate, I want to compare average monthly volume on Floor 1 with average monthly volume on (Floor 2 + Floor 3 combined ).  I am able to do that via creation of a group.    Each floor is comprised of a North and
      South Unit.  For example 1A and 1B comprise Floor 1.  I am stuck when it comes to changing the comparison to other floors.

       

      For example:

      1. I wish to have the capability to also readily compare average monthly volume on
        Floor 2 with the average monthly volume on (combined Floor 1 + Floor 3)
      2. And, I wish to have the capability to readily
        compare the average monthly volume on Floor 3 to the average volume on (combined volume on
        Floor 1 + Floor 2).

       

      In the workbook attached, the average monthly Floor 1 volume
      in January was 1.5 and the average monthly (Floor 2 + Floor 3) volume in
      January was 3.75.   I want to be able to do this for option A and
      Option B above.

       

      Appreciate any ideas/potential solutions for doing this.

      I am using Tableau v 10.3.
      Many thanks in advance!