Count

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Count

Description

Counts the number of occurrences of each item of text in the selected column.

 

Example

Count unique values in the 'Response' column:

 

how to count unique values in a column example

 

Inputs

One.

 

Options

Uncheck automatic new column name to set a name for the newly created column in New column name.

Select the Column whose values you wish to count.

Set Sort by depending on whether you wish to sort alphabetically by the Text in the left column or numerically by the Count in the right column.

Set Order depending on whether you wish to sort Ascending or Descending.

Uncheck case sensitive to convert everything to lower case before counting.

Check drilldown to allow double clicking a row in the data table to drilldown to the rows that contributed to this value in the upstream data.

 

Notes

Date and number values are treated as text.

Use Rename Cols to change the new column name.

Use Scale to convert the results to percentages.

If case sensitive is unchecked, the case of the first value encountered is used. You can use a Sort or Case transform before Count if you want to control the case shown.

 

Count case insensitive

 

See also

Ngram

Unique

Total

Moving

Pivot

Stats

Summary