Sorry but i can't open the workbook that you edited as the version is different.
1 of 1 people found this helpful
there are a couple of ways to do this, what I did here was to use measure names and measure values for color and angle, respectively.
if you want the label to show the percentage and not the counts you will need a couple of calculated fields
eg: [Percent Complete] = Sum([Completed])/(Sum([Completed]) +Sum([Not completed]))
Another option would be to create a Status calculated field (complete/not complete) put that on color and number of records on angle
If [Completed] = 1 and [Not completed] = 0 then "Complete"
elseif [Completed] = 0 and [Not completed] = 1 then "Not Complete"
hope this helps!
for the percent not complete, is the formula similar to the percent complete? and the measure names under the filter, is every selected?
i tried the status formula but it cannot but used at the angle in the marks card. Thank you.
That did not work for me as i need to filter the different individual staff and to show the percentage of completion as well as not completed in one chart.. and not all of the staff in one pie.. is there any solution? Thank you.
yes the percent not complete is the same as the percent complete, just change the fields.
For the second method, the status field goes on color (its a dimension so it is used to break up (or categorize) the data, then Number of records (or some kind of Count/CountD depending on your data) goes on angle ( angle has to be a measure)
hope that helps
for measure names, just drag measure names to color, and than remove the ones you do not want from the measure names card, Tableau automatically adds it to the filter shelf
I tried but then the angle and the number that came out isn't right. i kept getting over 100%. i tried both methods but i got almost the same issue..
Can you post your workbook so I can take a look?
Sent from my android device.
you are missing a set of parentheses in the denominator of the percent functions:
SUM([Not completed])/SUM([Not completed]) + SUM([Completed])
SUM([Not completed]) / (SUM([Not completed])+SUM([Completed]))
After I changed that I had to take every thing off of angle and color and put it back on using measure values and measure names.