This content has been marked as final. Show 3 replies
Please help find optimal solution.
I have data - drivers delivers documents to different locations. To some locations may be delivered several document.
I need to count, how many locations were visited by driver each month.
I use construction:
COUNT (Location_Code) AS Count_Delivery_Points
But I guess, this construction counts repeated locations, when several documents were delivered to same location.
Can you please tell me, how to cunt only unique values?
Thank you in advance!