Hello - I have a datetime field in format YYYY-MM-DD HH:mm:ss.000 that I then used hour() function to extract the hour. I now have an integer field representing the hour of the day. I want to create a visual in quicksight that shows a 24hr day and the frequency of data points for each hour of the day. Is there a way to bucket the data without creating an additional calendar?
Hi @isabella
why didn’t you used the format option to show it on hours?
What do you mean by “bucket the data”?
BR
Instead of extracting the hour, creating an additional calendar table, and joining the two tables I am looking for a way to use the original datetime field and somehow create hour buckets that the field will fall into , potentially creating a count of records per hour. Then those counts can be used to show the data points over the 24 hours in a day.
As @ErikG already said and based on your latest reply, changing the granularity should work.
I will be marking this as the ‘Solution’ . If you require further assistance provide us some sample data with the expected output , use the Arena ( NEW -- QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community - #6 by sagmukhe )