Hi guys,
I want to create a graph that shows how many people are available to work on a given day in the week. This is what I have so far:
The problem is, this graph pulls from a database that creates a new row for each new “availability” you add. The result is the data is skewed backwards if a given day has no “availability” at all. Like this:
(I removed day-4’s data, notice that day-5 and day-6 are now one day to the left)
At the moment I structure the graph’s input data like this:
- Search all [Schedules] and filter the list to only include shifts that are “Available”
- Group the filtered list by {Date} and count the number of shifts in each group
This creates the data for the graph, but with the flaw as described above.
How might I go about making the graph “aware” that a week has 7 days and show zero for the days where there are no shifts of the type “Available”?