5 Replies Latest reply on Jun 20, 2019 8:29 AM by Norbert Maijoor

Multiple independent dimensions as columns in a text table

Jaden Cornell Jun 19, 2019 11:21 AM

Hi,

I am attempting to build a table that has one dimension in the row shelf and three INDEPENDENT dimensions in the column shelf. What I mean is, I want to display the results of the same table calculation (a ratio) next to each other but following there respective columns. Tableau automatically stacks and "drills down" when I add more than one dimension into the column shelf. I want all three to remain separate. See below:

I am trying to replicate this table. I want to know what is x/y by company only, what is x/y by a yes or no question only, and what is x/y if age is over or under 50 only. I do not want x/y by company AND by Y/N AND by Age... Since they all share the time dimension, I want to display them all in the same text table and not have to do three separate worksheets.

Thanks

1. Re: Multiple independent dimensions as columns in a text table

Norbert Maijoor Jun 19, 2019 1:04 PM (in response to Jaden Cornell)
Hi Jaden,

Find my approach as reference below and stored in attached workbook version 10.5 located in your original post here:
Multiple independent dimensions as columns in a text table

1. Define a Union. A union in tableau is explained here
Union Your Data - Tableau

2. 01 D Dimension Desc:
if [Table Name]='Sheet1' then 'Company'
elseif [Table Name]='Sheet1$' then 'Y/N'
elseif [Table Name]='Sheet11' then 'Age'
end

3. 02 Display Dimension:
if [Table Name]='Sheet1' then [Company]
elseif [Table Name]='Sheet1$' then [Y/N]
elseif [Table Name]='Sheet11' then [Age]
end

4. Drag the required calculated calculated fields & measures to the indicated locations.

Thanks,
Norbert

Example nalmai v10.5.twbx 104.9 KB
Like Show 0 Likes(0)

Actions
2. Re: Multiple independent dimensions as columns in a text table

Jaden Cornell Jun 19, 2019 1:42 PM (in response to Norbert Maijoor)

Hi Norbert,

Thank you for your timely response. The three dimensions that I want to show the table calculation for (independently) all come from the same data source, so there isn't anything to do a union on... They are fields in a massive table containing hundreds of other fields. Is there not a way to prevent Tableau from "drilling down" when I add the 2nd and 3rd dimensions to the column shelf?

Thanks,
Jaden
Like Show 0 Likes(0)

Actions
3. Re: Multiple independent dimensions as columns in a text table

Norbert Maijoor Jun 19, 2019 10:58 PM (in response to Jaden Cornell)

Hi Jaden,

That's the exactly reason I "unioned' the same table;). I can imagine when you have 'hundreds' of other fields it is not feasible.

Regards,
Norbert
Like Show 0 Likes(0)

Actions
4. Re: Multiple independent dimensions as columns in a text table

Jaden Cornell Jun 20, 2019 7:58 AM (in response to Norbert Maijoor)

Hi Norbert,

How did you perform a union on something that doesn't have data separated by sheets (like an Excel file)? The three dimensions I want appear as fields that are part of a single, enormous SAS file. I am obviously able to get four separate text tables that have all of the information I want, so maybe I should change my question to: Is there a way to combine the results of four separate text tables (four worksheets)? Like this:

-Jaden
Like Show 0 Likes(0)

Actions
5. Re: Multiple independent dimensions as columns in a text table

Norbert Maijoor Jun 20, 2019 8:29 AM (in response to Jaden Cornell)

Hi Jaden,

Could you share your original dataset?

Thanks,
Norbert
Like Show 0 Likes(0)

Actions