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

    Calculate current weekly total ( automatic update )

    Jessica Lee



      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.


      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?