Display poll results with a pie chart

Displaying poll results in Klipfolio Klips is straightforward once you know how to tally text-based votes before they reach the chart.

Most poll tools record each vote as a separate row, with the response stored as text. That raw structure needs two preparation steps before Klips can render it accurately. Here is what a typical data source looks like:

	A	B
1	Date	Poll Result
2	3/18/2025	Yes
3	4/18/2025	Yes
4	4/18/2025	Yes
5	4/18/2025	No
6	5/18/2025	Not Sure
7	5/19/2025	Not Sure
8	6/19/2025	Not Sure

How to visualize poll data in Klips

The challenge with this data structure is tallying the results. Use the Klip Editor to prepare the data before it reaches the chart. Two functions do the work: CountDistinct and Group.

Tallying the results

CountDistinct counts each unique value in a column or array. Applied to column B:B, it returns 3 Yes, 1 No, and 3 Not Sure votes. Wrap it around a Slice function to strip the column header automatically, so the header never appears as a data point in the chart.

Labelling the results

Group eliminates duplicate values from a column and reduces a repeating list to one instance of each unique entry. Apply it to column B:B to produce the response labels: Yes, No, Not Sure. Use Slice here too, to exclude the column header from the chart.

The finished chart

Those two functions together produce a clean pie chart, with each slice labelled and sized correctly.

What if you prefer a bar or line chart?

The same method works with the bar/line chart component. Assign CountDistinct to the first series sub-component, then assign Group to the X Axis sub-component. Because this chart uses a single series, invert the X and Y axis in the Chart component's Properties tab.

Where you'll encounter this data structure

This pattern is common with survey tools such as Google Forms, SurveyMonkey, or Typeform. These tools record each response against the respondent's identity rather than producing a pre-summarized total, so the raw export always needs tallying before it can be charted.

For more on the functions available in Klips, see the Function Reference Guide.