Report with a Time Frame
Creating a Report with a Time Frame
This example will run through how you could use a report to pull data within a specific time frame.
-
In order to use dates for a report, they need to be converted to Unix timestamps, which is how dates and times are stored in the database. This can be done online at: https://www.epochconverter.com/.
-
Add in the Columns for your report with the relevant date field (for example 'transactions.date').
-
Select the Operators to limit the report using the date field. If you would like the report to pull data between two dates, add the date field as a column twice, and set one with the 'Greater Than' Operator and one as 'Less Than'.
-
Submit the report.
Example: A list of all transactions that occured between the beginning of the 1st January and the end of the 31st January.
Source Table:
Transactions
Columns:
transactions.date
transactions.purchase_method
Criteria:
| Column | Operator | Value | Meaning |
|---|---|---|---|
| transactions.date | Greater Than | 1546300800 | Transaction occured after 01.01.19 00:00 |
| transactions.date | Less Than | 1548935999 | Transaction occured before 31.01.19 11:59 |
Updated on 6th January 2020