5 Replies Latest reply on Jul 22, 2019 5:50 AM by vairavan ganesh

    Rolling hour calculation for comparison

    Jim L

      Let's say I have two weeks of data, down to the hour. I get my data updated hourly. I would like to compare:


      Total today, up to the latest hour


      Daily average of all previous days, up through the same hour.


      So, let's say I get number of apples sold, hourly:

      If it's 10am today, I want to compare all apples sold today through 10am, for all previous days in my data set, through 10am.


      I'm guessing probably some calculated fields with date logic, but curious if these a quicker window calculation?


      Thank you much in advance,