
1. Re: Converting Distinct Measure Values to a (row) Dimension
Deepak Rai Apr 13, 2018 9:46 AM (in response to Helen Stange)Hi Helen,
Here it is, you need to Pivot your data and follow the calcs I did to get this.
Pivot Data from Columns to Rows
Thanks
Deepak
If it Helps, pl mark it Helpful and CORRECT to close Thread.

facilities_v10.2.twbx 41.2 KB


2. Re: Converting Distinct Measure Values to a (row) Dimension
Simon Runc Apr 13, 2018 9:51 AM (in response to Helen Stange)1 of 1 people found this helpfulhi Helen,
What a very odd Excel file! So there are a few ways we could go about this. The easiest is to use the "Pivot" function on the connect to data screen
I've then created this calculation to filter out the NULL rows.
[Filter Out Null Rows]
ISNULL([Hotel Code])
Bringing this onto the filter shelf and setting to False.
Now for the (slightly) tricky part. As you want TRUE and FALSE and we don't have any data (to draw a mark) for FALSE ones (even if we left the [Filter Out Null Rows] not every combination would be present), so I've used a little Tableau trick called "data densification". It's a bit odd, but if you have 2 opposing blue (dimension) pills, and a table calculation, Tableau generates the missing marks, which we can access. Here's a quick GIF of that happening (notice the extra blue mark appear in Week 3/ Category D.
I then brought MIN(Number of Records) onto the Text tile, and set up the 2 following things
So the way the number 1 (well any positive number) is displayed is the word "TRUE" and any NULLS are displayed as "FALSE".
Hope that helps, and I've also done a more "Visual" version....Tableau is a data viz tool after all

3. Re: Converting Distinct Measure Values to a (row) Dimension
Joe Oppelt Apr 13, 2018 9:53 AM (in response to Helen Stange)Pivot the data. I created a new data source using your excel. In the screen shot I selected all the columns, and then did rightclick, "PIVOT".
The attached workbook shows what you get as a result. Tableau creates two fields: [Pivot Field Names] and [Pivot Field Values]. In your case the field values are the hotel numbers, and Tableau starts you off with that field as a measure, but you can convert it to a dimension:
And that's the status where I left your workbook (attached). Now you can do all sorts of things the way you want it.

Hotel_Features A.twbx 51.5 KB


4. Re: Converting Distinct Measure Values to a (row) Dimension
Helen Stange Apr 16, 2018 1:43 AM (in response to Deepak Rai)Thank you very much Deepak! This is exactly what I was looking for. I did try pivoting before but I think the key to this solution (which is what I was missing) are the calculated fields you set up to transform that pivot to my requirements for True/False. Much Appreciated  I'll use this trick a lot in the future

5. Re: Converting Distinct Measure Values to a (row) Dimension
Helen Stange Apr 16, 2018 1:56 AM (in response to Simon Runc)Wow Simon this is Tableau Wizardry I've never seen! A fantastic alternative to the calculated methods from Deepak, and furthermore a great opportunity to learn more about the "hidden"or at least "less obvious"possibilities within this software. Thank you very kindly for helping myself and other community members

6. Re: Converting Distinct Measure Values to a (row) Dimension
Helen Stange Apr 16, 2018 1:58 AM (in response to Joe Oppelt)Thanks Joe for pointing me in the direction of the Pivot  didn't realize this was even an option!