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?
Slicer: relative date's week format
Hello, with colleague we stumbled upon an issue. We are to create a report with revenues which to be sent each week to the various managers. Issue is, by default "Last week (calendar)" slicer is some sort of (American?) format which starts from Sunday and ends at Saturday instead of "normal" Monday to Sunday. That only brings confusion and is generally unwanted. We both spent some time looking this up but it seems to be nowhere to be found. The issue seems to be with default slicer itself, not with the dates. Welcome any type of solution, ideally if there is a community slicer adressing this issue. Thanks, Pavel