Hi!
Let’s say I have a view looking like the table below. The table shows the Customer id and what store they visited at some point in time. How do I create a measure that calculates the count of unique customers that have visited more than 1 different stores?
CUSTOMER | STORE |
123 | 55 |
123 | 23 |
111 | 52 |
111 | 52 |
142 | 85 |
125 | 22 |
117 | 46 |
193 | 71 |
Thank you in advance!