Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
08-12-2025
Solved

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...
  • HamzaJ's avatar
    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