traffic data in 6-hr intervals over a 12-week period

SAkram

Hi All,

I want to show data in 6-hour 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.

Paul Newcome

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: