Distint Count

[PandolaVaz]

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?

[Manoj_Kumar_ · Accepted solution]

Hello @PandolaVaz 

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