1 Reply Latest reply on Nov 19, 2018 11:05 PM by amar savale

    Create a table view to show where there is a null match between 2 values of a Dimension

    Simone Harris

      I'm trying to create a table view to show where there is a null match between 2 values of a Dimension.

       

      e.g. Data set contains Week as one Dimension, and Hostname as another Dimension.

      I want to compare Nov Wk 1 and Nov Wk 2 to create 2 separate worksheets to show:

       

      1) a list of Hostnames that are in Nov Wk 1 but NOT in Nov Wk 2

      2) a list of Hostnames that are in Nov Wk 2 but NOT in Nov Wk 1

       

      This is the simplified dataset:

       

        

      WeekHostname
      Nov Wk 1Server 1
      Nov Wk 1Server 2
      Nov Wk 1
      Nov Wk 1
      Nov Wk 1Server 5
      Nov Wk 1Server 6
      Nov Wk 1Server 7
      Nov Wk 1Server 8
      Nov Wk 1Server 9
      Nov Wk 2Server 1
      Nov Wk 2Server 2
      Nov Wk 2Server 3
      Nov Wk 2Server 4
      Nov Wk 2Server 5
      Nov Wk 2Server 6
      Nov Wk 2
      Nov Wk 2
      Nov Wk 2Server 9

       

       

      How do I do this in the simplest way possible? Do I need to create a calculated measure?