Skip to main content

Quick Intelligence - Keywords

You can use the following keywords in the Quick Intelligence Designer's search bar.

General​

top n​

Generates the top specified number of records from a sorted result

Example

( top 10 ) ( total sales_total ) ( by location_type )

bottom n​

Generates the bottom specified number of records from a sorted result

Example

( bottom 10 ) ( total sales_total ) ( by location_type )

sort by​

Sorts the result set by a column in your dataset

Example

( total sales_total ) ( sort by year desc )

by​

Grouping results by a column in your dataset

Example

( total sales_total ) ( by DayName )

Date / Time​

... before ...​

Before a date

Example

( total sales_total ) ( final_sale_date before 2019-15-13 )

... after ...​

After a date

Example

( total sales_total ) ( final_sale_date after 2019-15-13 )

... between ...​

Between the range of values or time period (comma separated)

Example

( total sales_total ) ( final_sale_date between 2021-04-23, 2022-01-23 )

... today​

The date is equal to today's date

Example

( total sales_total ) ( final_sale_date today )

... yesterday​

The date is equal to yesterday's date

Example

( total sales_total ) ( final_sale_date yesterday )

... last [n] ...​

Date equal to last n day(s) / week(s) / month(s) / quarter(s) / year(s). The number is optional.

Example

( total sales_total ) ( final_sale_date last 5 months )

Yearly​

Group the result by year

Example

( total sales_total ) ( Yearly )

Quarterly​

Group the result by quarter

Example

( total sales_total ) ( Quarterly )

Monthly​

Group the result by month

Example

( total sales_total ) ( Monthly )

Weekly​

Group the result by week

Example

( total sales_total ) ( Weekly )

Daily​

Group the result by day

Example

( total sales_total ) ( Daily )

by ... hourly​

Group the result by hour from a date.

Example

( total order_item ) ( by item_time_sold hourly )

by QuarterName​

Group the result by the name of the quarter

Example

( total sales_total ) ( by QuarterName )

by MonthYear​

Group the result by the year and the month name

Example

( total sales_total ) ( by MonthYear )

by MonthName​

Group the result by the year and the month name

Example

( total sales_total ) ( by MonthName )

by DayOfMonth​

Group the result by the day of the month

Example

( total sales_total ) ( by DayOfMonth )

by DayOfWeek​

Group the result by the day of the week

Example

( total sales_total ) ( by DayOfWeek )

by DayName​

Group the result by the day name Monday, Tuesday, Wednesday, etc

Example

( total sales_total ) ( by DayName )

Text​

... begins with ...​

Attribute value starts with a value

Example

( total sales_total ) ( State begins with Cal )

... not begins with ...​

Attribute value does not start with a specific value

Example

( total sales_total ) ( State not begins with Cal )

... ends with ...​

Attribute ends with a specific value

Example

( total sales_total ) ( State ends with nia )

... not ends with ...​

Attribute does not end with a specific value

Example

( total sales_total ) ( State not ends with nia )

... contains ...​

Attribute contains specific value(s) (comma separated)

Example

( total sales_total ) ( MonthName contains January, February, March )

... not contains ...​

Attribute does not contain a specific value(s) (comma separated)

Example

( total sales_total ) ( MonthName not contains January, February, March )

Number​

total​

The count of records of a text attribute or sum value of a numbered attribute within your dataset

Example

( total sales_total ) ( by day )

avg​

The averaged values of the specified column in your dataset

Example

( avg sales_total ) ( by MonthName)

max​

The max value of the specified column in your dataset

Example

( max sales_total ) ( by State )

min​

The min value of the specified column in your dataset

Example

( min sales_total ) ( by State )

sum​

The sum of the values in the specified column in your dataset

Example

( sum sales_total ) ( by State )

unique count​

The total number of unique values in the specified column in your dataset

Example

( unique count location_name ) ( by State )

Percentage ...​

A number or ratio expressed as a fraction of 100 based on the specified column in your dataset

Example

( Percentage sales_total ) ( by DayName )

Median ...​

The middle value of a sorted list for the specified column within your dataset

Example

( Median sales_total ) ( by location_name )

TopQuartile ...​

The value at the top quartile record (25%) for the specified column in your dataset

Example

( TopQuartile sales_total ) ( by location_name )

BottomQuartile ...​

The value at the bottom quartile record (25%) for the specified column in your dataset

Example

( BottomQuartile sales_total ) ( by location_name )

FlexRate (aggregate function) ...​

Flex rate allows us to determine the average value of a specific parameter by aggregating data, performing a calculation on the total, and then distributing the result equally based on the count of records within a group

Example

( FlexRate avg sales_total ) ( by location_name )

Comparison​

... = ...​

Equal operator. This can be attr = value or attr = attr. Currently used for filtering

Example

( total sales_total ) ( State = Utah )

... &lt> ...​

Not equal operator, currently used for filtering

Example

( total sales_total ) ( State <> Utah )

... > ...​

Greater than operator, currently used for filtering

Example

( total sales_total ) ( sales_total > 0 )

... < ...​

Less than operator, currently used for filtering

Example

( total sales_total ) ( sales_total < 1000 )

... >= ...​

Greater than or equal to operator, currently used for filtering

Example

( total sales_total ) ( sales_total >= 1000 )

... <= ...​

Less than or equal to operator, currently used for filtering

Example

( total sales_total ) ( sales_total <= 1000 )

Empty / Not Empty​

... is empty​

Value is empty, or isnull

Example

( total sales_total ) ( sales_rep is empty )

... not empty​

Value is not empty, or is not null

Example

( total sales_total ) ( sales_rep not empty )