5 Replies Latest reply on Oct 10, 2013 12:27 PM by Shawn Wallwork

    Calculate current weekly total ( automatic update )

    Jessica Lee

      Hi

       

      I am trying to compute weekly totals.

      For example, let's say today's date is 10/10.

      When I open up a dashboard, I'd like to diplay daily totals of last week. (10/3~10/10)

      This is what I want to display.

       

      Day10/310/410/510/610/710/810/910/10
      Number of Records100200300400500600700800

       

      But I'd like to update it automatically with most recent data without manual filtering.

      I created a calculated field called 'Current Date' and used today() to get current date.

      Then I created 7 different fields, [Current Date]-7, [Current Date]-6, ..... [Current Date]-1

      This gives me the display of last week's dates, but I couldn't find the records for each day.

       

      Anyone have any idea?

       

      Thanks!