|
You may need to set the correct date format:
The macros may work incorrectly if the incorrect date format is specified.
You can select the date format from the list os predefined date formats or specify it as a string value. See the next table for details:
String Value | Example |
---|---|
d - day of month (no leading zero) | 1 |
dd - day of month (two digits) | 01 |
D - day of week | Mon |
w - week of year (no leading zero) | 1 |
ww - week of year (two digits) | 01 |
m - month of year (no leading zero) | 1 |
mm - month of year (two digits) | 01 |
M - month name short | Jan |
MM - month name long | January |
y - year (two digits) | 19 |
yy - year (four digits) | 2019 |
Qi - quarter (Q+digit) | Q1 |
hh - hour (two digits) when using a 24-hour time format | 01 |
HH - hour (two digits) when using a 12-hour time format | 01 |
mm - minute (two digits) | 01 |
ss - second (two digits) | 01 |
o - day of the year (no leading zeros) | 1 |
oo - day of the year (three digits) | 001 |
If you use the string value for setting the date format, you can combine and customize them to your needs, as follows:
Table Filter
In the page view mode
If needed to filter and edit the table on the go, switch to the page edit mode, select the macro and click Show filter. All the options of the filtration pane are available in the page edit mode. |
In the macro browser
Pivot Table
Chart from Table
Table Transformer
|
You can set the dynamic time intervals in the date picker in the Table Filter macro in the following format:
If you need to set some complex interval, enter it as a single string, like: -2m 3w 5d. The current browser date is used as a starting date for data filtration according to the specified time intervals.