Creating a Chart from Non-Numerical Data for a Dashboard

Horace ✭✭✭
edited 12/09/19 in Smartsheet Basics

I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet.

More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart that shows the percentage of IT issues that were email related, hardware related, software related, etc.).

What do I need to do to get the percentage of each activity total for the column in order to create this chart in a dashboard?