4 Replies Latest reply on Dec 24, 2014 11:51 AM by Lionel Yu

Display data from columns as Pie Chart

Joshua Lowry Dec 17, 2012 11:23 AM

I have a csv that has a header row and one data row. This information represents total values from my application. I would like to see a pie chart of column headers L, M, N, O where the sum of those columns is the total. The other columns are not a part of this total. I'm still pretty new, but my first thought is that maybe I can transpose the data somehow.

It would be nice to do this generically so that I can create other charts with the rest of the data, for example headers A, G, X, Z as a single pie chart.

1. Re: Display data from columns as Pie Chart

Jonathan Drummey Dec 17, 2012 11:55 AM (in response to Joshua Lowry)

You 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
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Display data from columns as Pie Chart

Joshua Lowry Dec 18, 2012 7:40 AM (in response to Jonathan Drummey)

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?
Like Show 0 Likes(0)

Actions
3. Re: Display data from columns as Pie Chart

Jonathan Drummey Dec 21, 2012 3:13 PM (in response to Joshua Lowry)

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
Like Show 0 Likes(0)

Actions
4. Re: Display data from columns as Pie Chart

Lionel Yu Dec 24, 2014 11:51 AM (in response to Jonathan Drummey)

Hi Jonathan, do you have any advice on setting up the Custom SQL to do this?
Like Show 0 Likes(0)

Actions