1 of 1 people found this helpful
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.
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?
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:
Or you can do it in Custom SQL, which takes a bit more effort to set up.
Hi Jonathan, do you have any advice on setting up the Custom SQL to do this?