-
2. Re: how to create a table for three categorical (dimension) variables?
Joe Smith Dec 29, 2015 7:21 AM (in response to Norbert Maijoor)Thank you very much, Norbert!
I learn that you created calculated fields for each item in the dimension variables City and Region.
I wonder if there is a more efficient way to do this without creating calculated fields.
I also would like to ask, if you don't mind, how to extract the table created in Tableau into Excel in the same layout (8 columns and 5 rows in your example file), i.e. without exporting the data embedded in the current table as a flattened csv file with only two columns.
Thank you, again!
-
3. Re: how to create a table for three categorical (dimension) variables?
Norbert MaijoorDec 29, 2015 7:33 AM (in response to Joe Smith)
Joe!
Within "my sight" I only can of "calculated fields".
Concerning your last remark I think you are refering to "Data-Intepreter" and the "pivot-functionality" within tableau
Quick Start: Use Data Interpreter to Prepare Your Excel Data Source for Analysis
-
4. Re: how to create a table for three categorical (dimension) variables?
Matt LuttonDec 29, 2015 8:19 AM (in response to Joe Smith)
To answer your question about "how to extract the table created in Tableau into Excel in the same layout..."?
The easiest way to accomplish this is -- select all marks, then use CTRL+C to copy the data, go to Excel and use CTRL+V and you will get a data set (summarized to the level of detail in your worksheet) that mimics the layout of your view. NOTE: This is VERY different from using the Export option -- test both out and see the difference.
In terms of your original question, it would be ideal if you could post a packaged workbook with sample data, as well as your expected output, as a lot of the possibilities in Tableau depend entirely on how your data is structured.
Happy to help if you can post a sample TWBX using one of the sample datasets that ships with Tableau -- best of luck!
The copy and paste functionality is discussed at the links below, if you need clarification -- you can also copy and paste data INTO Tableau as a Clipboard data source (a text file).
Copying and Pasting Between Tableau Desktop and Excel | sqlbelle's musings
Paint By Numbers: Copy and Paste within Tableau is your friend
Cheers,
-
5. Re: how to create a table for three categorical (dimension) variables?
Joe Smith Dec 29, 2015 8:55 PM (in response to Matt Lutton)Thank you very much, Norbert and Matt!
To Matt,
It seems the copy-paste method only works for Tableau Desktop, not for Tableau Public... What a pity...!
What I want to do is to copy the table in the example Tableau file attached and shown below to Excel in the same layout (see image 2) below.
Table in Tableau:
I want to get a table in Excel in the same layout as shown below:
However, following the suggestion of copy-and-paste, what I got in Excel is a table shown below which is not in the same layout as it is in Tableau.
Table in Excel that is copied and pasted from Tableau:
I assume I missed something important here, and I appreciate if you can kindly advise!
Thank you both very much!
-
example.twbx 9.7 KB
-
example.xlsx 8.9 KB
-
-
6. Re: how to create a table for three categorical (dimension) variables?
Joe Smith Dec 29, 2015 9:09 PM (in response to Matt Lutton)As to my question about creating table for three categoriecal variables, here is an example file that I'm not able to produce the results I want.
What I want is to create a table shown below:
However, I can only get a table for two of the three categorical variables in Tableau:
Appreciate your kind advice, greatly!
-
population.xlsx 9.0 KB
-
population.twbx 9.5 KB
-