header.jpg

Log2Stats Documentation

Date ranges

You can add up to 8 date ranges for each favorite report. Click to add a new report and select appropriate date range from the menu.

Log analytics date ranges in Log2Stats

You can right click on the code field to edit the selected date range, right click the Title field to select predefined date range, right click first or last date to directly select date range via calendar or right click on the Filter field to apply instant filter to the selected date range.

You define date ranges via the code field. There are two types of date ranges: direct and relative. Direct date range is a simple range between two fixed dates:

2010.12.01 - 2010.12.31
defines date range starting at 2010-Dec-01 0:00:00 1st and ending at 2010-Dec-31 23:59:59
Relative date range

Relative date ranges allows you to set up date ranges related to the date of the latest entries in the database.

The syntax for relative date ranges uses several symbols: d for days, w for weeks, m for months, y for years. The code for relative date range has two fields delimited with : symbol. First field defines start of date range. Second field defines the number of days, months, weeks or years to include in the range.

Some date ranges are explained in the table below:

Date range codeDescription
:This code will use all database
dLatest day in the database
d-1Previous day
d-6 : 7Latest 7 days in the database
d-27 : 28Latest 28 days in the database
w : 1Current full week. It is not the same as d-6:7
w-1 : 1Previous full week. Starts on Sunday
mCurrent full month. I.e it starts on Jan-1st and ends on Jan-31th
m-1Previous month.
m-5:6Previous 6 full months including current one.
yCurrent full year. Starts on Jan-1st, ends on Dec-31th
y-3:3Previous 3 full years. Not including current one.