Count

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Count

Description

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

 

Inputs

One.

 

Options

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.

 

Notes

Date and number values are treated as text.

You can use Rename Cols to change the new column name.

 

See also

Pivot

Stats

Summary