count data for weekdays in the future
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?