Value Count in Case Attribute

Overview #

The calculator counts the number of distinct values of a selected case attribute.

Common Uses #

• Calculate number of unique customers or vendors.
• Add the value count to the dashboard.

Settings #

• Column Name: Select the column name for which you would like to calculate the value count.

Examples #

Example 1 #

Let’s calculate the count of distinct vendor names in our cases. Select ‘Vendor’ in ‘Column Name’ box.

Output:

In our dataset, we have 3238 distinct vendor names.

Example 2 #

Let’s calculate the count of distinct case variants in our cases. Select ‘~calc~Variant’ in ‘Column Name’ box.

Output:

In our dataset, we have 121 different variants of our processes.