Hello, I have some sample data and am having difficulty rolling up. The data has Location, Cardholder, Date of Visit, WeekRefDate (this is datestart("Date of Visit"), WeekYear. What I want to know is by Location how many Cardholders have visited the office at least once, twice, three+ times.
@vinieme12 thanks for the suggestion. that is really close to what I am looking for. The difference is I want the left hand column to be the office that the visit was made in not the week. So for a given week selected I want to see the by office performance of # of visits.
WeekRefDate serves the same purpose as IsoWeek in your aggr I believe. I tried this based on your post but I only get Once. Any ideas? Really appreciate the help feel like we're getting close!
This helps getting closer... I can see who is in what day, how many days in a week. But the counts are not aggregating properly. They all should fall into 1x or more, 4 of them should be 2x or more, 3 of them should be 3x or more.
aggr dimension expression:
=aggr(if($(v_Full_Week_Swipes)>=3,'3x or More', if($(v_Full_Week_Swipes)>=2,'2x or More', if($(v_Full_Week_Swipes)>=1,'1x or More'))),[Location Description],WeekRefDate,[Badge Number])