When creating a report for a customer or for your site, you must determine the period you want to analyse: The last 6 months? The last 30 days? Focus on a particular date?
You will therefore configure the analysis period on your report.
So, when you add data blocks (graphs, tables, etc.) these dates will be used to create the visualisations to display your data.
Note that it is possible to customise the analysis period of a block.
It is necessary to differentiate between the default period of the report and any customised block periods.
You have to define some terms to find your way through the explanations.
For example: You want to create a report over a rolling 6-month period. It is therefore necessary to configure a default period of the report which includes 2 dates and a type of data aggregation.
A start date (D1) and an end date (D2).
In the example above: D1 = March 2018 and D2 = Sept 2018
Here is how to configure this type of period
As you can see on the screenshot above: The start and end dates can be fixed or relative.
For our example, we want a rolling period. Therefore, the start and end dates must always be relative to today's date.
It is important to differentiate between 2 elements:
1/ In the Report settings, when we talk about relative dates, we must understand that it is relative to today's date.
2/ The difference with customising the study period of a block is that the dates are relative to the dates chosen to configure the default period of the report.
In our example the default period of the report is:
D1 = March 2018 and D2 = Sept 2018
In a block you will therefore choose your D1 and D2 in relation to March 2018 or Sept 2018
If you have read and understood this article in its entirety, you should be a black belt in this!
Have fun in your dashboards and combine various aggregations and study periods to support your analyses.
Feel free to contact us on the online support, if you have any further questions.