Astroraf
08-12-2025Data Pipeline
How to achieve a Booking Summary by Day of the Week by Hour of the day?
Hi DRay ,
I am trying to achieve a pivot table with a heatmap that shows the day of the week at the top and the hours on the y-axis. I currently have this so far:
But as we can see that the...
- 08-13-2025
Hey Astroraf ,
As far as i know this will not be possible on the front-end. If it is possible to change it in the datamodel, then you can change de weekday labeling to something like 1. Monday, 2. Tuesday etc. With a javascript you can hide 1. etc.
Another option would be to use a formula per weekday field. So per weekday add something like the following:
contribution(booking_id, weekday) . Filter weekday on monday. CLick OK and rename the formula to monday. Repeat for every weekday. Now you can sort them in any order you want.
Hamza