...

...

How to use date filter periods

Guided NLQ makes use of the existing date filter periods already available within Yellowfin, along with a few extras (see the tables on Date Filter Periods for more information).

Once you’re familiar with the date phrase options available for Guided NLQ, read on to learn more about how to use them.

Typing vs selecting

Due to the large number of options available, Guided NLQ doesn’t display all the date filter options available when you ask a question. It provides a list of the most popular options only. However, if you’d like to use date option that isn’t displayed, just start typing:

As you can see, typing reduces the visible selection list and may introduce additional, less popular phrases.

Combining dates

A date typically consists of a day, a month and a year. In Guided NLQ:

• Use the date selector for a specific day.
• Use the month name or abbreviation alone to query data only from that month in the current calendar year.
• Use the month name or abbreviation with any four-digit year to query data only from that month in the calendar year you typed.
• Use a four-digit year to query data only from that calendar year.
• Use the quarter abbreviations with or without a calendar year to query data from those specific periods.
• Use the financial quarter abbreviations with or without a calendar year to query data from those specific periods.

Any of these combinations will be translated by Guided NLQ into a set date.

For reference, the table below illustrates some examples.

...

What are these orange dots?

...