I would like to count the number of rows which have the same 3 variables
e.g. Name, Country, City
my current proposal was the code below, but there i was only able to select one variable but i need all three.
count("Personal ID") OVER ( PARTITION BY "Name")