traffic data in 6hr intervals over a 12week period
Hi All,
I want to show data in 6hour intervals over 12 weeks (Feb 2024 till April 2024). How do I create a dashboard for it?
Columns include:
Only if I can know the total number of tickets received for the past 12 weeks in 6 hour timely interval for the past 12 weeks
Any help would be highly appreciated.
Answers

This can be done, but getting a dynamic setup built can get a little complex.
Start with manually entering the number 339 in a text/number column called "Number" in row 1 and 338 in row 2. Then dragfill down until you get down to zero.
Then in a date type column called "Date", enter this column formula:
=TODAY(0  INT(Number@row / 4))
And in a text/number column called "Time", use this column formula:
=IF(MOD(Number@row, 4) = 3, "00:00", IF(MOD(Number@row, 4) = 2, "06:00", IF(MOD(Number@row, 4) = 1, "12:00", "18:00")))
And the Primary Column is renamed to "Labels" and uses this column formula:
=Date@row + " " + Time@row
Once you get that set up, let me know, and we can move on to the next steps. Below is what we should have so far:
Help Article Resources
Categories
Check out the Formula Handbook template!