2 of 2 people found this helpful
First, change your chart type to "Pie".
Next, drag the dimension that tells you whether a user has updated their data to the "Color" area.
Finally, drag "Number of Records" or a COUNTD([VoterId]) to the Angle area.
Hope this helps! If not, some sample data may help us help you!
But I don't have detailed information about voters or the voters who have updated their data.
The row in my table has 2 columns showing the amount of voters (citizens) and amount of voters who have updated their data, per section, city and so on.
Look at the image below.
- Num Secao is the SectionID
- Qtd Aptos is the amount of voters in the section
- Quantidade Eleit Bio is the amount of voters that have updated their data
Can you share the packaged workbook?
I decided to change my table in order to have a new column showing whether a voter has updated his data or not.
So I'll be able to create a pie char the way Derrick sugested.