Hello,
I am doing web analytics for a newspaper and I am trying to find a smart way to count unique users (cookies) per url in a dashboard. The tricky part is that I cannot summarizre and aggregated count of users per url to get the website's total unique users (because one user may visit more than one url).
So what I would like to do is to concatenate all cookies that visited an url into one cell, then i would like to count all the unique "cookies" based on whatever i have selected. So that if i filter out a section, a url or just a date, then I would be able to count the number of unique cookies.
Is this possible in the way i imagine it, or in any other way?
