in our business we have a feature that lets users book a timeslot and weekday to recieve their service (weekly or BiWeekly) , for example ,user X booked his service to be Friday 10:00 AM Weekly , user Y has booked his service to be every Tuesday 1:00 PM BiWeekly
So user X will recieve his service Friday 10:00AM (Every Week), and user Y will recieve his serive Tuesday 1:00 PM (Every Two Weeks)
the request is :
create a matrix for every future date , how many users have booked a specific timeslot , ex:
| | tuesady 07-06-2021 | Wednesday 07-07-2021 | Thursday 07-08-2021 | Friday 07-09-2021 | Saturday 07-10-2021 | Sunday 07-11-2021 | Monday 07-12-2021 | tuesady 07-13-2021 | Wednesday 07-14-2021 | Thursday 07-15-2021 | Friday 07-16-2021 | Saturday 07-17-2021 | Sunday 07-18-2021 | Monday 07-19-2021 | tuesady 07-20-2021 | Wednesday 07-21-2021 | Thursday 07-22-2021 | Friday 07-23-2021 | | | |
| 10:00 AM | | | | 1 User | | | | | | | 1 User | | | | | | | 1 users | | | |
| 11:00 AM | | | | | | | | | | | | | | | | | | | | | |
| 12:00 PM | | | | | | | | | | | | | | | | | | | | | |
| 1:00 PM | 1 User | | | | | | | | | | | | | | 1 User | | | | | | |
so as you can see , dates are in the futute , and do not exist in our database ,
the data i have is :
-User ID
-weekday
-time
-service date ( data will be shown once service date has passed , if the date hasnt come yet , data will be NULL)
ex for the table :
| User ID | Week day | Time | Serive date | frequency |
| 124 | Tusday | 6:00 PM | 6/27/2021 | weekly |
| 567 | Friday | 11:00 AM | NULL | weekly |
| 566 | Sunday | 4:00 PM | NULL | biweekly |
| 433 | Friday | 3:00 PM | NULL | biweekly |
so how can i count total users who booked a service each weekday (weekly/biweekly) for dates in the futute?
