You can choose the following time periods:

  • Day > Example: .History(1,Day)
  • Week > Example: .History(5,Week)
  • Month > Example: .History(10,Month)
  • Year > Example: .History(3,Year)


Here's how to do it: 

  • Go to 'Formulas' > 'New formula' > 'Empty Formula' > 'Advanced editor'.
  • When you start typing, you'll get a drop down with look up functions (Count, Sum, Avg etc.).
  • Select the look up function you wish to use:

  • Select the data source you wish to refer to:

  • If you want to filter on a field, type ',' after the data source. Select the field you wish to filter on:
  • Add the '.History(,)' modifier to the formula. In '()' you type the a number and the time period, e.g. one month:

Formula #1: This formula displays items sold one month back from the widget's start date on the dashboard. 


Please note
that this formula doesn't include today's numbers. If you wish to display today's numbers as well, you add it to the formula like this:

Formula #2: This formula displays items sold one month back from the widget's start date including today's numbers. 


Overview of time periods and examples of combinations:

  • The widget's time period is current day (widget's start date is today):

.History(1,Day) > The widget will return yesterday's number.
.History(2,Week) > The widget will return the number from yesterday and 2 weeks prior.
.History(1,Month) > The widget will return the number from yesterday and 1 month prior.
.History(1,Year) > The widget will return the number from yesterday and 1 year prior.

  • The widget's time period is current week (widget's startdate is Monday):

.History(1,Day) > The widget will return Sunday's number.
.History(2,Week) > The widget will return the number from Sunday and 2 weeks prior.
.History(1,Month) > The widget will return the number from Sunday and 1 month prior.
.History(1,Year) > The widget will return the number from Sunday and 1 year prior.

Did this answer your question?