First step is I want to get Average Sales By Hour From yesterday to 7 days ago Second Step, Average Values are like (12 AM -3 , 1 AM - 5 , 2 AM - 5,-------etc) so cumulative values in graph, 12 - 3 , 1-8 , 2 -13 by hourly third -Line graph in Average Cumulative Values by Hour Vs Current Day Cumu…

Hello @ThawZin , I am not sure I entirely understand how you are wanting to group the hours in the x-axis. Each grouping has overlapping times with other groupings, so that will make this a lot more complicated to create. I at least feel like we could figure out a way to create an average sales per h…

Thank for your solutions. Check my requirement again. [image] This two line are cumulative sales by hours. June 2 is current day (now) June 1 is previous . but instead of only June 1 cumulative sales , i want average cumulative value by hour for 7 days. my formula is runningSum(sum(status), […

@WLS-DM let me hear your feedback please.

Hello @ThawZin , I went through and did some testing on this and I think I have found a solution. I unfortunately don’t have a good dataset to display this for a 24 hour day, so I instead built it for the 7 days in a week. You can convert these calculations to show hour by hour instead of day by day,…

@WLS-DM , here is sample dataset for my request. I hope it is okay for you. Pleaes help me more. Last 7 Days Hour Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Today 0 3 1 2 3 3 6 3 3 1 2 6 0 1 2 7 2 1 2 1 7 12 2 1 8 1 2 3 6 8 3 8 6 3 6 3 4 7 8 8 3 7 2 7 3 5 8 3 3 3 8 1 8 6 …

@WLS-DM , I got the solution like Current Day Cumulative Sales By Hour : runningSum(sumOver(sum(ifelse(truncDate(“DD”, now()) = truncDate(“DD”, createdAt), status, NULL)), [{Convert Time}]), [{Convert Time} ASC], ) Last 7 Day Average Cumulative Sales By Hour : runningSum( avgOver( sumIf( …

Hello @ThawZin , I am not sure it matters here, but I would use an ifelse function instead of a sumIf. I just do not particularly like how those functions work and sometimes they do not play well with the LAC-W aggregations like avgOver. Also, I am wondering if you add the empty partition brackets a…

@WLS-DM , great , thanks. Got it now . Cus I did filter on visual but my issue is like even though current time is at 7 AM , but trend is showing at other time that’s why trend is flat , how to avoid it. Current Formula is runningSum(sumOver(sum(ifelse(truncDate(“DD”, now()) = truncDate(“DD”, cre…

Hi @WLS-DM , let me hear your feedback.

Hi @WLS-DM , May I know your feedback

Movies Average By hour

Q&A

WLS-D June 24, 2025, 2:38pm 14

Hey @ThawZin

I think this would be easier to troubleshoot in arena. Would you be able to recreate this there with sample data so we can work through this easier?:

Topic		Replies	Views
Cumulative Total By Hour and Average Total Cumulative Total By Hour From Last 7 Days Q&A quick-sight , Business-Intelligence-Engineer	8	98	October 14, 2024
Quicksight Accumulative Q&A quick-sight , Business-Intelligence-Engineer	6	84	July 5, 2025
Media de Vendas dos ultimos 7 dias Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	82	February 24, 2025
I have a field "time_range" which holds hours data at which row was created (like 0:00 - 0:59, 13:00 - 13:59 etc.) and I want to visualize the average of count of every time range. How can I do that? Also I want to order the time range by hour Q&A quick-sight , calculations	8	682	April 12, 2023
Showing the average values in a time series visual Q&A quick-sight , visuals	4	469	June 1, 2023

Movies Average By hour

Related topics