10 Replies Latest reply on Apr 25, 2018 2:22 AM by Maikel Korff

    Help with Calculation

    Venkat Sivaneswaran

      Hello,

       

      We get hour to date data each day and compare to same day last week. In the example below, today's data is up to 11 AM. but last week's data is available for entire day.

       

      Is there any way I can filter out the future hours for the day so that I can get total volume until 11AM for today and -7 days ?

       

      So, I expect the application volume to be total of 6+18+29+43+28 = 124

      and the -7 volume to be 8+22+24+45+44 =  143

       

      Is there a way to do Hour of Application Date = Hour of Application Date - 7 Days so that I can exclude the data in RED?

       

      Thanks in advance.

       

       

      Message was edited by: Venkat Sivaneswaran

       

      Message was edited by: Venkat Sivaneswaran

       

      Message was edited by: Venkat Sivaneswaran