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

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

Date / Time​

... before ...​

Before a date

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

... after ...​

After a date

... 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

... 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.

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

Weekly​

Group the result by week

Example ( total sales_total ) ( Weekly ) :::

Daily​

Group the result by day

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

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

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

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

... 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

... 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)

... 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

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

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

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

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

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

Comparison​

... = ...​

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

Example ( total sales_total ) ( State = Utah ) :::

... <> ...​

Not equal operator, currently used for filtering

... > ...​

Greater than operator, currently used for filtering

Example ( total sales_total ) ( sales_total > 0 ) :::

... < ...​

Less than operator, currently used for filtering

... >= ...​

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

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