Expand my Community achievements bar.

SOLVED

Distint Count

Avatar

Level 2
Hello
can you guide me how do I count distinct records
for example: I'm filtering several deliverys I need to know the count per delivery.
Delivery A = 20 records
Delivery B = 30 records,
is it possible to display this data in display the target?

PandolaVaz_0-1684964905900.png

PandolaVaz_1-1684964988737.png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @PandolaVaz 

 

In your query activity, Use the configuration from the screenshot below  to get this output.

 

Manoj_Kumar__0-1684990021384.png

 


     Manoj
     Find me on LinkedIn

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hello @PandolaVaz 

 

In your query activity, Use the configuration from the screenshot below  to get this output.

 

Manoj_Kumar__0-1684990021384.png

 


     Manoj
     Find me on LinkedIn