Include the option to compare percentage of values in a chart.
Thank you! This is a great idea and your feedback helps us prioritize development.
I've outlined a possible solution to your situation below but I'll add your comment to our internal ideas board.
Potential Solution
Create a Summary Table with the field you're interested in. For my example, the {Pass/Fail Field} has a value of either "Pass" or "Fail".
Create a field that has a common value, I'm using "Status"
Select {Common Field}, {Pass/Fail Field} and {Count of 50 States.Table1} and create a Stacked Bar Chart. Under Layer options change the Layout to Stacked percent.
If you wanted to highlight, for example, records with a Passing Grade, you could change the sorting and make the Fail symbology transparent.
I know this isn't a donut chart but it presents the information in a similar way.
For the KPI card, create a new field that calculates the sum of the variable you created in the Summary Table.
Create one last field that represents the percentage for each category type (you could combine these steps but wanted to separate them for clarity)
Finally, select {Percent} and create a KPI card. Filter the card to whatever value you want to display ("Pass" in my example). Under Layout options change the Layout to Gauge. Set the Target to whatever you want (70 for me) and the Max value at 100. Change other settings as needed.
