I have around 606,000 rows of appointment data and want to pull certain things out of it.
First, I want to split it out by site, and then the number of appointments booked on each date at each site.
Iterate through `Site` column For every `site` in `Site` For every `date` in `Date` Count total number of appointments booked
Hopefully this example makes things a little clearer.
Ultimately, I want to be able to look at the next seven days and see how many appointments are booked at each site across each of the seven days.
How can I achieve this?