0 Replies Latest reply on Jul 21, 2019 9:22 PM by vairavan ganesh

    Rolling Hour Analysis every 5 min

    vairavan ganesh

      Hello Guys,

       

      It's been a week I'm having my hands-on tableau.

       

      I have the frequency of flights to every 5 minutes during the day (see attachment).

      I would like to identify the frequency for rolling hours in 5 min interval.

       

      Is it possible to group the frequency to desired intervals? 288 rows in total.

       

      1st row 0:00 - 0:55

      .

      .

      .

      last row Until 23:00 - 23:55

       

      Please assist.

       

      I'm able to crack this in excel, using count ifs and other functions. But would like to do this in tableau itself.

      Check excel attachment my desired output is in the rolling 1 hr tab.

       

      Thanks in advance!

      Vairavan