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 today's date.
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 today's date including today's numbers.
The example data source looks like this:
Today we have Oct. 11 2017, so the number on the on the dashboard will then be either 9 or 15:
Number shown on the dashboard with #1 formula.
Number shown on the dashboard with #2 formula.