Resample data over number of N minutes/hours/days

Question and answer
#1

Hello everyone,

I want to calculate the average of a measure over N number of days or hours or minutes. I know how to do this in a calculated field but the problem is the date granularity shows only minutes, hours and days.
dates problem
instead of this, I want to see something like this
12 AM
8 AM
4 PM
and whatever starting hour it should show only 8 hours interval starting from that hour.

#2

Hi,

Thank you for reaching out. I’m not 100% certain of the scenario you are trying to achieve, but it looks like you might be trying to extract the hour from the date as part of this. Have you looked at the Extract() function to get the hour portion of the date? Extract - Amazon QuickSight

Best,
Sean