Thanks. I should clarify, the test and control are not under the same variable. They are measures listed separately test and control.
Can you please post how your data is laid out?
Sure. The data is calculated from SQl already. So its only one row of calculations. It looks something like this
Period Test Control Total
Overall 45 55 100
So when read into Tableau, there are separate measures for test, control, total
The only dimension is Period
It sounds like the two 'metrics' are separate columns in your datasource. Is this correct? For example, if you have one row of data in Excel as follows;
You could import this into Tableau and create a pie chart using measure names and measure values as follows;
- Drag measure names onto the 'Color' button
- Change the 'Marks' type from Automatic to Pie
- Drag Measure Values onto the Size and Angle button
- Remove the unwanted measures from the Measure Values pane so you just have the SUM(Control Metric) and SUM(Test Metric)
Haha that was very simple I cant believe I didn't figure it out myself. Thanks!