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 days of the week do not sort in the order from Monday to Sunday. Is there a way to achieve a custom column value? I also want to be able to click on a column, i.e., Friday then take me to a week with the all the bookings for that week like this.
Can this be achieved in Sisense?
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
