Percentages

Canteaug

I am trying to show the percentages of types of findings in a dropdown column that are in a specific county. For example: Show the percentage of findings that are "None" for the county "Holms". How would I go about doing that?

Kerry St. Thomas

For simplicity's sake, I assume your data includes ten rows where column "County" says "Holmes"; of those, four where the value in "Findings" is "None." …meaning 4 / 10 = 40%. Translating this into formulas, you need to count the number of rows where County = Holmes, and separately count the number of rows where County = Holmes AND Findings = "None." You'll need two formulas that count different numbers of rows.

If you have the premium Pivot App, you can use that to do the math for you. (Suggest you put the counties as rows, finding as column, and Count of, for example, Row ID's as value.) If you don't have the Pivot app, you might need to set up a KPI sheet - assuming you're going to do a similar thing for other counties you're doing this for, so you'll be able to refer to the county name by clicking on the cell instead of manually typing the county name like below. You'll need to set up the formulas - I prefer to use COUNTIFS (even if there's only one condition) because it's easier to remember.

=COUNTIFS([County]:[County],"Holmes") / COUNTIFS([County]:[County],"Holmes",[Findings]:[Findings],"None")

More on the COUNTIFS function: https://help.smartsheet.com/function/countifs
More on formulas, with a great search function: https://help.smartsheet.com/functions
More on Pivot app: https://www.smartsheet.com/marketplace/premium-apps/pivot-app

Canteaug

@Kerry St. Thomas Hi Kerry, I appreciate your information. That is exactly what I am trying to do. We have 82 counties and I want to be able to do something similar to this below:

Is it possible to show this in a pie chart by breaking it down by county so I can see those errors per county?  The same with the percentage of findings by category

Canteaug

I'm assuming I would have to do this for each category. @Kerry St. Thomas

Kerry St. Thomas

The formula looks like you've set it up correctly.

Is it possible to show 82 data points on a pie chart? Yes. Would I recommend it? No. That many color variations are not going to be discernable to most people, and the labels will be difficult if not impossible to read. I'd recommend aggregating the 82 counties into a handful (like 4 or 5 tops if you are attached to a pie chart visualization) of larger regions if possible. Let the dashboard visualization be a high level summary of data, and provide a report (either surfaced on the dashboard, or that opens when clicking a visualization or a link) for more granular information.

This sounds like a pretty significant product Good luck!