Displaying poll results using the pie chart component

Pie charts are a useful way of displaying poll results.

In our example, the pie chart component is used to display three categories of responses: Yes, No, or Not Sure.

Example:

Goal: Use COUNTDISTINCT and GROUP functions to visualise poll results.

  • Values: COUNTDISTINCT( B:B )
  • Labels: GROUP( B:B)

Where B:B is the column that contains the poll results.

A

B

DatePoll Result
3/18/2013 Yes
4/18/2013 Yes
4/18/2013 Yes
5/18/2013 No
6/18/2013 Not Sure
7/18/2013 Not Sure
8/18/2013 Not Sure

Location

Action

For our example

  select the Klip component  
From the Properties tab enter a name for the Klip Title Team Event
  select the Values sub-component  
From the formula editing toolbar click Insert function, Data Manipulation, COUNTDISTINCT  
With values selected select the column that contains the poll results. COUNTDISTINCT( B:B )
If the column has a row header, ensure that the column containing the poll results is selected click Wrap current value in function, Data Manipulation, SLICE COUNTDISTINCT( SLICE( B:B, start, end )
Click COUNTDISTINCT to highlight the whole formula select Evaluate current selection Result: 1, 3, 3. (Note: shows the total number of votes in each category).
  select the Labels sub-component  
From the formula editing toolbar click Insert function, Data Manipulation, GROUP  
With values selected select the column that contains the poll results GROUP( B:B )
If the column has a row header, ensure that the column containing the poll results is selected click Wrap current value in function, Data Manipulation, SLICE GROUP( SLICE( B:B, start, end )
Click GROUP to highlight the whole formula select Evaluate current selection Result: No, Not Sure, Yes. (Note: The name of each category is displayed.)

Feedback and Knowledge Base