Pie Chart using aggregation and words in one of the columns

samgenson
samgenson
edited 01/30/25 in Smartsheet Basics

My question is in two parts:

  1. I want a pie chart to display the percentage out of 100 that a certain field is. For example, if I have ten values in a column that are one of: "State", "Federal", "Community" where there are 3 State, 3 Federal and 4 Community.
  2. Right now, it won't let me use words at all, so I have to put a numeric value to them (1, 2, and 3). Instead of it showing up as three entities on the pie chart, it shows up as 10 separate entries.

Thank you in advance for your help.

Tags:

Answers