Page History
...
- ‘This Year’ differs from ‘ThisYear to Date’, which differs from ‘This Year to Now’.
- This Year = The full calendar year, from January 1 to December 31.
- This Year to Date = Data for this year only to today. Future data is ignored.
- This Year to Now = Data for this year to this point of time of today (down to the millisecond, if a field supports that granularity). Future date is ignored.
- These differences are important when your dataset contains future dates that you may wish to exclude or include.
- ‘Financial week’/’Business 'Business week’ refers to the work week (business-days) as defined by your system’s Java locale setting.
- The financial year dates are set through the Yellowfin Admin Console (under the Config settings for Region).
...
Phrase | Description | Dynamic update? | Usage | Availability |
|---|---|---|---|---|
This Financial Business Week Start | Query data from a specific, single day — the first day of the current business week (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Financial Business Week End | Query data from a specific, single day — the last day of the current business week (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Financial Business Week to Now | Query data from the current financial week to now, specific to the exact time of day (based on the time the report is run). | Yes | Date with Time component | System wide |
Now Minus 2 Weeks | Query data from the past 14 days to now, specific to the exact time of day (based on the time the report is run). | Yes | Date with Time component | System wide |
Now Minus 3 Weeks | Query data from the past 21 days to now, specific to the exact time of day (based on the time the report is run). | Yes | Date with Time component | System wide |
This Week | Query data from this calendar week (based on the date the report is run). This uses the Java locale (your system settings) to dictate the start day of the week. | Yes | Date with/without Time Component | System wide |
Last Week | Query data from the last calendar week (based on the date the report is run). This uses the Java locale (your system settings) to dictate the start day of the week. | Yes | Date with/without Time Component | System wide |
Last Financial Business Week | Query data from the last business week (based on the date the report is run). This uses the Java locale (your system settings) to dictate the start day of the week. | Yes | Date with/without Time Component | System wide |
Last 4 Weeks | Query data from the last four calendar weeks before this week (based on the date the report is run). This uses the Java locale (your system settings) to dictate the start day of the week. | Yes | Date with/without Time Component | Not in Guided NLQ |
Last 8 Weeks | Query data from the last eight calendar weeks before this week (based on the date the report is run). This uses the Java locale (your system settings) to dictate the start day of the week. | Yes | Date with/without Time Component | Not in Guided NLQ |
Last 12 Weeks | Query data from the last twelve calendar weeks before this week (based on the date the report is run). This uses the Java locale (your system settings) to dictate the start day of the week. | Yes | Date with/without Time Component | Not in Guided NLQ |
...
Phrase | Description | Dynamic update? | Usage | Availability |
|---|---|---|---|---|
This Quarter Start | Query data from a specific, single day — the first day of the current quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Quarter End | Query data from a specific, single day — the last day of the current quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Financial Quarter Start | Query data from a specific, single day — the first day of the current financial quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Financial Quarter End | Query data from a specific, single day — the last day of the current financial quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Quarter Start | Query data from a specific, single day — the first day of the last quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Quarter End | Query data from a specific, single day — the last day of the last quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Financial Quarter Start | Query data from a specific, single day — the first day of the last financial quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Financial Quarter End | Query data from a specific, single day — the last day of the last financial quarter (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Q1 | Use this shortened format for annual quarters to query data from a specific quarter. | No | Date with/without Time Component | Guided NLQ only |
FQ1 | Use this shortened format for financial year quarters. | No | Date with/without Time Component | Guided NLQ only |
This Quarter | Query data from the current quarter, including future dates (based on the date the report is run). | Yes | Date with/without Time Component | System wide |
This Quarter to Date | Query data from the current quarter to today (based on the date the report is run). This excludes any data for future dates in this month. | Yes | Date with/without Time Component | System wide |
This Quarter Last Year | Query data from this quarter, a year ago (based on the date the report is run). | Yes | Date with/without Time Component | System wide |
This Financial Quarter | Query data from the current financial quarter, including future dates (based on the date the report is run). | Yes | Date with/without Time Component | System wide |
Last Quarter | Query data from the last quarter (based on the date the report is run). | Yes | Date with/without Time Component | System wide |
Last Financial Quarter | Query data from the last quarter (based on the date the report is run). | Yes | Date with/without Time Component | System wide |
Quarter before Last | Query data from the previous quarter to the last quarter (based on the date the report is run). | Yes | Date with/without Time Component | Not in Guided NLQ |
Next Quarter | Query data for the upcoming calendar quarter after the current date | Yes | Date with/without Time Component | System wide |
Annual phrases
Phrase | Description | Dynamic update? | Usage | Availability |
|---|---|---|---|---|
This Year | Query data for this calendar year. | Yes | Date with/without Time Component | System wide |
Last Year | Query data from the last calendar. | Yes | Date with/without Time Component | System wide |
This Year Start | Query data from a specific, single day — the first day of the current calendar year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Year End | Query data from a specific, single day — the last day of the current calendar year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Financial Year Start | Query data from a specific, single day — the first day of the current financial year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Financial Year End | Query data from a specific, single day — the last day of the current financial year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Year Start | Query data from a specific, single day — the first day of the last calendar year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Year End | Query data from a specific, single day — the last day of the last calendar year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Financial Year Start | Query data from a specific, single day — the first day of the last financial year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
Last Financial Year End | Query data from a specific, single day — the last day of the last financial year (based on the date the report is run). | Yes | Single date | Not in Guided NLQ |
This Year to Now | Query data for this year so far, specific to the exact time of day (based on the time you submit your question). | Yes | Date with Time component | System wide |
This Year to Date | Query data for this year so far (based on the date your report is run). | Yes | Date with/without Time Component | System wide |
This Financial Year To Date | Query data specifically for this the current financial year (based on up to the present date. | Yes | Date with/without Time Component | System wide |
This Financial Year | Query data for this financial year (based on the date your report is run). This your report is run). This phrase won’t display if your financial and calendar years are the same. | Yes | Date with/without Time Component | System wide |
Last Financial Year | Query data from the last financial year. This phrase won’t display if your financial and calendar years are the same. | Yes | Date with/without Time Component | System wide |
2021 | Type a four-digit year to query data from that year only. | No | Date with/without Time Component | NLQ only |
Last Year to Date | Query data from the start of last year until the current date one year earlier. | Yes | Date with/without Time Component | System wide |
Last Year Month to Date | Query data from the start of the month one year earlier, to the current date one year earlier. | Yes | Date with/without Time Component | System wide |
Special phrases
Phrase | Description | Dynamic update? | Usage | Availability |
|---|---|---|---|---|
All Time | We highly recommend you always provide a date with your query to avoid resource overload in returning too much data. However, if you want to see results since your data began you can use this phrase. | — | — | NLQ only |
...