How to calculate worst hour and best hour of the day by Visits and show them as separate columns?
Hello Community,
I am looking to create a dashboard for our stakeholders where they wanted to see the Worst hour in a day by Visits and the Best Hour in a day by Visits as a separate columns.
I have below table which shows Visits / Day and looking to have 2 new columns which can show me the worst hour (in terms of visits) and number of visits on that hour, best hour(in terms of visits) and number of visits on that hour.

The output iam looking for can be like below, just sharing it as an example:
| Visits | Best Hour | Best Hour Visits | Worst Hour | Worst Hour Visits |
Day |
|
|
|
|
|
May 2, 2022 | 8,114 | 11:00 AM | 465 | 12:00 AM | 3 |
May 4, 2022 | 79,018 | 9:00 AM | 1,003 | 4:00 AM | 8 |
May 5, 2022 | 65,111 | 7:00 AM | 5,045 | 5:00 AM | 200 |
Is there any way I can get these metrics in Adobe Analytics. Any help or suggestions would be greatly appreciated.
Thank you very much!
Satish




