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.
- Column Name: Select the column name for which you would like to calculate the value count.
Example 1 #
Let’s calculate the count of distinct vendor names in our cases. Select ‘Vendor’ in ‘Column Name’ box.
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.
In our dataset, we have 121 different variants of our processes.