-
1. Re: Display data from columns as Pie Chart
Jonathan Drummey
Dec 17, 2012 11:55 AM
1 of 1 people found this helpfulYou can build a pie chart using Measure Names/Measure Values. Drag Measure Names onto the Color Shelf, Measure Values onto the Rows Shelf, and then you can use the Measure Names Filter and/or drag measures off the Measure Values list.
Jonathan
-
2. Re: Display data from columns as Pie Chart
This was very helpful in making me realize I can use the MeasureNames and MeasureValues more, but it just wouldn't work for me for some reason.
What I ended up doing was dragging each item I wanted to measure onto the chart (not in rows or columns) and it created the filter. This automatically added the MeasureNames to the Rows. I dragged the MeasureNames from Rows over to Color. This automatically filtered out the other measures for me. Then I manually switched the Marks over to Pie and dragged MeasureValues onto Angle.
Is there a way to make the Label a combination of MeasureName and MeasureValue?
-
3. Re: Display data from columns as Pie Chart
Jonathan Drummey
Dec 21, 2012 3:13 PM
I don't know of an easy way to make the label a combination of both, there's no access to Measure Names/Values. The slightly more difficult way is to unpivot your data so that each column is now a row in the data, with the column name now being a member of a dimension. You can do that in Excel using the Tableau data reshaper, more info here:
http://kb.tableausoftware.com/articles/knowledgebase/preparing-excel-files-analysis
Or you can do it in Custom SQL, which takes a bit more effort to set up.
Jonathan
-
4. Re: Display data from columns as Pie Chart
Hi Jonathan, do you have any advice on setting up the Custom SQL to do this?