My raw data has Name, location name, Date of login. I have a virtual table which gives me location name, Frequency Group and Login Counts. Here Frequency Group and Login Count are Measures. What I really want to do is -
- Count How many logins per Location (Should be able to filter by year/month)
- Then Compare it with Frequency Group to see which bucket that count falls into
- Then Again count- How many Locations fall into each bucket. Meaning there are “50” locations with “1 time” logins, "20 " locations with “2-5 times logins” etc…
I did First 2 steps. I’m not able to do 3rd. Can someone help me. Here is the sample data after step 2.
Virtual data.xlsx (8.7 KB)