As part of our business requirements, I am working on a dashboard where we need to create a heat map based on the day of the week and the hour of the day to visualize the number of calls. However, we are facing challenges sorting the time format from AM to PM. Could you please guide me on how to address this issue?
Since there is no time data type this is not straightforward. For the solution have created a hour field to have all the dates set to 1/1/1990 keeping the hour value intact. And tweaked the formatting to recreate this. Sample solution 36076
Hello @Biswajit_1993, I will mark @prantika_sinha previous response as the solution. Please let us know if you have any remaining questions. Thank you!
Hi @WLS-DM , Thank you for the response.
Is there any way to sorting the weekday without having 1 Sunday, 2 Monday, 3 Tuesday instead of that we need the simple Weekday.
Thank you so much, @prantika_sinha, for your quick solution! I tried multiple approaches but couldn’t find a solution until yours worked for me.
This is a wonderful platform created by the Quick Sight team. It really helps a lot, allowing us to share our experiences and provide solutions to one another.
Agreed, This is a great platform to learn and share knowledge.
For your other query on the Weekday sorting, I think @Sanjeeb2022 's suggestion works the best, considering we do not have scope to use off visual field for sorting.
