Sometimes it is useful to run a report more than once. A good example would be an "emergency bookings listing" which could have the system generate every evening for the next day, in case your ISP or our servers had problems. You can do this by checking the Repeat? box.
which exposes some extra fields:
Let's say the current date is 1st Jan 2000, and I want the report for tomorrow's bookings to land in my inbox every evening just before midnight, starting tonight:
Each day at 23:50 the system will run the report for the period starting in 10 minutes and finishing in one day and 10 minutes.
Sometimes you will want regular weekly historical reports - KPIs for instance. Let's say you want the KPI report to be ready for you every Monday morning, starting on Monday 20th June 2022:
Each Monday the reporting system will adapt the period start and finish so it works for the previous week.
Now let's consider a report where each day we want to consider some KPIs for next week, so we can check that we are on track to achieve our target.
In this case the system will use reporting periods as follows:
Report date | Range |
20/06/2022 07:00 | 27/06/2022 - 03/07/2022 |
21/06/2022 07:00 | 27/06/2022 - 03/07/2022 |
22/06/2022 07:00 | 27/06/2022 - 03/07/2022 |
23/06/2022 07:00 | 27/06/2022 - 03/07/2022 |
24/06/2022 07:00 | 27/06/2022 - 03/07/2022 |
25/06/2022 07:00 | 27/06/2022 - 03/07/2022 |
26/06/2022 07:00 | 27/06/2022 - 03/07/2022 |
27/06/2022 07:00 | 04/07/2022 - 10/07/2022 |
Because the Period Start and Period Finish are both Mondays and they are a multiple of 7 days apart the system "knows" that you are interested in weeks, even though the report is being run every day. This means that if you want to run a daily report with the reporting window shifting forward one day at a time you must avoid reporting periods that are a multiple of 7 days - you should use a day longer or shorter. In addition to handling weeks in this special way, the system will do the same for months, quarters and years.