6 Replies Latest reply: Mar 20, 2018 2:45 PM by Sunny Talwar RSS

    Graphing Rangesum with conditions

    Charles Litten

      Hi, I am trying to chart a rangesum function of my current daily sales compared to my previous year.

       

      My function for the current day is:

       

      RangeSum(Above(Total Count({<Date= {"$(=Max(Date))"}>}Sales), 0, RowNo()))

       

      Chart:

      Capture.PNG


      It works perfect except it plateaus at the current time instead of ending. I was wondering if there is a way to graph it with conditions like "time is less than or equals to reloadtime()".  No matter what I do, it flattens at that time.


      I'd prefer it if the blue line just ended when it reaches the most recent reloadtime


      Thanks!