I have a table which contains bookings for an event I am running, with one row for each booking and a column for the date of the booking. I am trying to create a line chart which shows me the progress of the number of bookings over time. So the X axis would have one label for each day of the month - even if there was no booking on that day, and the Y axis would have the number of bookings, i.e. the number of rows, matching the date.
I have tried a few things without success, so I wonder if someone could help with this?