Distinct count aggregation

Karthik_Anbusekar
Karthik_Anbusekar
in General

I am not sure how to apply distinct count as aggregation while do group by ?
There is check box "distinct", even though i enable that still does not give distinct count.

Can someone help me to apply distinct count as aggregation in group by

Tagged:

Comments

  • Josh Boxer
    Josh Boxer Administrator
    edited September 1

    I suggest testing the Group step/action with some simple/limited volume data to understand how it works.

    image.png

    Count:

    image.png

    Count by Country column:

    image.png

    Update Count aggregate using Distinct and select the column to be checked for distinct/uniqueness:

    image.png image.png

    Or without grouping:

    image.png
  • Karthik_Anbusekar
    Karthik_Anbusekar

    Thanks @Josh Boxer ,
    Now it works,

Categories