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:
How do I do this in the simplest way possible? Do I need to create a calculated measure?
Please find the Below Attachment and Screen Shot marked as Correct or Helpful For You.
Note:-See Both Sheets i.e. Sheet 1 and Sheet 2
Amar D. Savale
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...