How to achieve a Booking Summary by Day of the Week by Hour of the day?

Question

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?

HamzaJ · Accepted Answer

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...