Here's a script solution. It builds two new tables. One matches the StartDate to every date between then and today, and has a day of week field in it. One matches an AsOfDate to every date between then and a year ago (or as early as your data goes). The chart is then a simple pivot table:
An amusing way to see it working is to select an AsOfDate, and then use the up and down arrow keys move the selected date forward or backward, and watch it increment and decrement the column for that weekday.
You can use the function weekday(Date) during load. This will get you the weekday numer and inthe front end youcan give count(weekday field) where weekday feild = 0 (for Monday)
At the backend I'm already loading the weekday ... but still got some issues because this is in a separate table which is not connected to the Call table containing the startdate
Think I should do some tricks with expressions on the frontend to solve this ... which will do something with the summing of the weekday ...
Here's a script solution. It builds two new tables. One matches the StartDate to every date between then and today, and has a day of week field in it. One matches an AsOfDate to every date between then and a year ago (or as early as your data goes). The chart is then a simple pivot table:
An amusing way to see it working is to select an AsOfDate, and then use the up and down arrow keys move the selected date forward or backward, and watch it increment and decrement the column for that weekday.
