May I ask how to create a table like the one shown below in Tableau that include three categorical variables?
A table summarizing the population by gender according to city or region of a country:
Thanks!
Dec 29, 2015 3:52 AM
Joe!
Not sure what you are trying to achieve but find my attempt in attached workbook version 9.0
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!
Dec 29, 2015 7:33 AM
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
Dec 29, 2015 8:19 AM
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,
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!
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!
Dec 30, 2015 12:39 AM
Joe!
May be to simple;) But what about just two sheets... next to each other?
