Summary Count Of Days / Events For Month

[Harry Basra]

Hi all,

I’m trying to create a summary of booking events. I have a starting block which someone on here kindly helped me with. However i want to apply this on a month on month basis.

Total Number of days: this should be the total number of days people can book on, this includes weekends. (the business opens on the 7th of Jan after xmas, hence why this shows 25 days). This needs to be for each month.

Total Number of Booked Dates: This shows the total number of days in the month which have bookings on them. It doesn’t matter how many events have been booked on those particular days I just need to know the total number of days with events on them. From the pivot I can see that this 22 days, however I’m unable to perform an automatic count for each month.

Total No of booked days with Room 1 & 2: This is the same as above however it only needs to show days for Room 1 & 2 and for each month.

Many thanks