Unique Count

Modified on Tue, 4 Apr, 2023 at 3:34 PM

Description

This function helps to identify the unique number of values in a single column or the unique number of input parameter combinations in dataset.


Application

With this step you can quickly check how many distinct input value combinations you have in your dataset.


How to use

  • Assign a dataset to the field Data.
  • Select the Columns to check for unique set of values.
  • Click Apply

An info box with the number of unique values for the selected columns will appear. You don't get an information about the frequency of each unique value.


Examples

Consider the following dataset with one ID column and three Input columns:

  • If you select only Input1 for evaluation the unique value count will yield 3. The unique values are [1, 2, 3].
  • If you select Input1 and Input2 the unique count will yield 9 as for example (1,2) and (2,1) are not considered to be the same. The unique values are [(1,1), (1,2), (1,3), (2,1), (2,2), (2,3), (3,1), (3,2), (3,3)].
  • If you select Input1 and Input3 the unique count will yield 6. The unique values are [(1,1), (1,2), (2,2), (2,3), (3,3), (3,1)].

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article