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

Options
SAkram
SAkram ✭✭✭
edited 04/22/24 in Formulas and Functions

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.

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!