Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 the current financial year 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 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

...