Custom Datetime aggregate

Question & Answer
,
1

Hello,
In a visual, I would like to do a sales count, aggregated per 12hours.
However, in my visualization, the datetime aggregate option is only possible for Minute, Hour, Day, Week, Month…
How can I aggregate per 12hours easily?
image

Thank you

2

Hi @pam - Welcome to AWS QuickSight community and thanks for posting the question. In this case if you create a calculated field for 12 hours and do the aggregations.

Hi @Biswajit_1993 @David_Wong @Naveed - Any feedback on this.

Regards - Sanjeeb

2 Likes
3

Hi,
You can do this by calculation field round on 1,2,3… hours and based on this like if new_calu between 1 to 12 and do your sale count in other calculation.

This is the logic you can do it.

regards,
Naveed Ali

3 Likes
4

We will do that. Thank you

1 Like