1 Reply Latest reply on Aug 28, 2018 5:39 PM by swaroop.gantela

    Window_Sum over time

    Adam Webb

      Hi All,

       

      My work requires a lot of rolling hour calculations, something which can be tricky in tableau.

       

      I'm currently looking at a daily profile of number of records per minute, my data is laid out similarly to the below:

      TimeNumber of occurences
      00:012
      00:020
      00:035
      00:046
      etcetc

       

      The time is a continuous field, and I'd like to keep it that way. If I set the time field to discrete and use WINDOW_SUM(SUM([Number of occurrences]),0,59) then I get logical answers, however as soon as a I set the time field to continuous the window sum results change significantly. Can anyone tell me how window_sum deals with continuous times, or how I can set a window sum within a time window rather than number of records?

       

      Thanks

       

      Adam