How to extract unique fields from a report that has multiple columns?

ihayes
Participant III

I have a table report that shows the number of times each customer visits a web site URL for each day. The. report has four columns:

  • Website URL  - the web page
  • Customer code - a customer reference
  • Date - the date of the visit
  • Visits count - the number of times a customer visited that web site URL on this date

However, what I really want is a unique list of the customers who vistied a specific page more than 3 times on a day

Hence, the report I really want is just one column

  • Customer code

Is there a way to build a custom filter around the web site URL, date and visit count per date?

The solution has to be in a report or a custom dimension in a report.  there is no lattitude to change the underlying LookML

0 0 128
0 REPLIES 0
Top Labels in this Space
Top Solution Authors