Creating a Chart from Non-Numerical Data for a Dashboard

kss5229

It would be great to be able to create pie charts or bar graphs on my dashboard that displays percentage and/or counts of types of activity from a column in a sheet.

For example an IT tracking sheet with a column that has a dropdown menu, easily creating a chart widget from that column that would count the number of types of events (for a bar chart) or alternately, a percentage of each type of events for a pie chart.

I know this can be done by creating helper columns using the "countif" function, but in smartsheets that are already large, it would be great to not need to create more columns (or an additional smartsheet) to function as the in-between for this type of data.