Appearance
Field Date Calc
To uses date calc a date filter must be used in the query (half year, quarter, month, week or day). With this filter, the values are aggregated.
Date calc can be edited in the field-list or the inspector.
Date Calc Values
In this sample the query has a month filter with the value 2020-03. Also the offset-month is set in the database with the value 7. This meens the fiscal year starts in july (7) and ends in june (6).
| Date Calc | Info |
|---|---|
| None | Date calc is not used: 2020-03 |
| Year | Sum: 2020-01 till 2020-12 |
| YearToDate | Sum: 2020-01 till 2020-03 |
| EndOfYear | Last value of the year: 2020-12 |
| Rolling | 2019-02 till 2020-03 |
| OffsetYear | Sum: 2019-07 till 2020-06 |
| OffsetYearToDate | Sum: 2019-07 till 2020-03 |
| EndOfOffsetYear | Last value of the offset year: 2020-06 |