Context Fixed values from 1 to 24 (hours of day) // Currently I don’t know how to implement this My dataset has a timestamp field, and I created a calculated field that extracts the hour from that field (Eg., YYYY-MM-DD 20:mm:ss → hour_of_day = 20) named hour_of_day Expected Visual in a vertica…

Hi @tobinguyen do I get you right. The issue is that not every hour is represented in your data and you want to make sure there is always every hour represented in the chart from 1-24? One solution is to join a table that contains all hours from 1-24 (eg. in a csv file). You need a simple table w…

@Nico I have tried CSV solution but my dataset is from an S3 datasource and I still don’t know how to use custom query to format timestamp to hour of day. I tried to join my record dataset with that csv dataset but my calculated field is not in joining field dropdown

@tobinguyen I guess you created the calculated field in the analysis. It is also possible to add a calc field In the dataset pane. Then you should find it as joining field. Best regards, Nico

@Nico my calculated field is in the dataset field but when I set the join clause all calculated fields aren’t showing up Calculated field is in dataset fields [Screenshot 2025-02-07 at 16.48.25] But not shown in the join clause [Screenshot 2025-02-07 at 16.45.21] I found this Q&A that said i…

@Giridhar.Prabhu Thanks, I’ll check out this video

@Giridhar.Prabhu I watched the video and tried it, but it doesn’t seem to work in my case (or maybe I did it wrong, sorry I’m very new to Quick Sight). This is an example of my dataset, which only has two columns, and I need to count the number of userIDs at each time point during the day. In the ca…

Hello @tobinguyen , here is an analysis that includes the calculated fields I created in the video that was linked: Advanced Calculated Fields This should help you create the static 1-24 hours that you want in your visual.

Hi @WLS-DM Sorry for the late reply, I was busy and off for a while. First, thanks for your video and response. But I have a few questions and would appreciate your help. I see that in your example, you’re using denseRank and then grouping the results into three groups. In my case, if there are f…

Hi @tobinguyen , It’s been awhile since last communication took place on this thread, did you have any additional questions or were you able to find a work around for your last question in the mean time? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you!

Does Quick Sight support fixed values for X-axis?

Q&A

Giridhar.Prabhu February 7, 2025, 11:06am 6

Hi @tobinguyen

You can come up with your 24 hours as fixed values and map your dataset values into each bucket from your dattaset values field using this video from @WLS-DM

Regards,
Giri

Topic		Replies	Views
Hour Buckets in Quicksight Q&A analysis , filters , quick-sight	10	943	June 22, 2023
How to add a calendar day as x-axis for showing daily incoming and closed bar chart Q&A charts , quick-sight , Business-Intelligence-Engineer	5	573	February 29, 2024
Data points by hour of the day Q&A date , quick-sight , Business-Intelligence-Engineer	3	643	November 28, 2023
Calculo de datos / Campo calculado Q&A quick-sight , level-aware , calculations , Business-Intelligence-Engineer , tables	11	504	February 20, 2024
[VISUAL_CALC_REFERENCE_MISSING] error on custom calculation in values -- bar Graph Q&A formulas , analysis , error , quick-sight , visuals , Business-Intelligence-Engineer	4	91	November 14, 2024

Does Quick Sight support fixed values for X-axis?

Related topics