Forum Discussion
distnict count based on multiple column
I would like to check repeated values in my table based on Day and location column. Here is my Sample data: VisitorID Day Location 1501 1 Location 1 1501 1 Location 2 1501 1 Loca...
Hi,
I dont think your result matches the dataset you provided?
In file i added to this reply I grouped your data on location and then did a distinctcount on visitor by day.
https://drive.google.com/file/d/1K-Vf63La87CMhaZJI9fnRo3FY-hi99Df/view?usp=sharing
I hope this is what you were looking for.
Robbe
RobbeVL
Impactful Individual
Impactful IndividualHi,
I dont think your result matches the dataset you provided?
In file i added to this reply I grouped your data on location and then did a distinctcount on visitor by day.
https://drive.google.com/file/d/1K-Vf63La87CMhaZJI9fnRo3FY-hi99Df/view?usp=sharing
I hope this is what you were looking for.
Robbe