4 Replies Latest reply on Sep 9, 2016 12:43 PM by David Li Branched to a new discussion.

    Running_SUM excluding prior days and using date filter

    nigora.sharipova

      Hello Tableau Experts,

       

      My report shows hourly trend defaulted on one day which is controlled by a date parameter. I want to show a running total for that day based on the last available (refreshed hour). For example: if my report has data from 12AM through 7AM, i would like it to indicate that Metrix X = 100 for those hours. However, when i try the following calculation, i get the running total for all the prior data points in the report.

       

      if (LOOKUP(ATTR(date),0)=[Date Range])

      then running_SUM(sum(metric))

      end

       

      * Date Range is the date parameter which limits the end user to filter one day at a time.

       

      Any help would be much appreciated!