x-bees analytics

Document description

Updated:

Permalink:

Keyword reference

Use keywords to help define a search.

General

Note: When using the top or bottom keywords without specifying a number (n), the number defaults to 10.

Keyword	Description
top n	Generates the top n items from a sorted result. Examples: top 10 sales rep revenue top sales rep by count sales for average revenue > 10000 sales rep average revenue for each region top
top n measure1 by attribute\|measure2	Calculates top n items, then sorts the top items by another measure or attribute. Contrast with top n (swaps the order of operations). Example: top 10 sales rep revenue by profit margin
bottom n	Generates the bottom n items from a sorted result. Examples: bottom 25 customer by revenue for each sales rep bottom revenue average bottom revenue by state customer by revenue for each sales rep bottom
sort by	Sorts the result set by an attribute or measure. Examples: revenue by state sort by average revenue descending revenue by customer sort by region sort by state
by <measure>	Treats the measure as an attribute and groups the result set by it. Examples: cost by revenue product by quantity purchased

Date

Keyword	Examples
after	order date after 10/31/2014
before	order date before 03/01/2014
between ... and ...	order date between 01/30/2012 and 01/30/2014
daily	shipments by region daily
daily year-over-year	growth of revenue by order date daily year-over-year
day	count monday restaurant
day of week	revenue by day of week last 6 months count shipments Monday
growth of … by ...	growth of sales by order date
growth of … by … daily	growth of sales by order date daily
growth of … by … monthly	growth of sales by date shipped monthly sales > 24000
growth of … by … quarterly	growth of sales by date shipped quarterly
growth of … by … weekly	growth of sales by receipt date weekly for pro-ski2000
hourly	visitors by page name hourly
last day by	customers last day by referrer
last month	customers last month by store
last month by	customers last month by day
last n days	visitors last 7 days
last n months	visitors last 10 months by day
last n quarters	visitors last 2 quarters by month by campaign
last n weeks	visitors last 10 weeks by day
last n years	visitors last 5 years by revenue for sum revenue > 5000
last quarter	customers last quarter sale > 300
last week	customers last week by store
last year	top 10 customers last year by sale by store for region west
month	revenue by month last year
month	commission January
month to date	sales by product month to date sales > 2400
month year	commission by sales rep February 2014
monthly	commission > 10000 monthly
monthly year-over-year	growth of revenue by receipt date monthly year-over-year
n days ago	sales 2 days ago
last n days for each month	sales last 2 days for each month
last n days for each quarter	revenue last 15 days for each quarter
last n days for each week	total sold last 2 days for each week
last n days for each year	revenue last 300 days for each year
last n hours for each day	sales last 2 hours for each day
n months	visitors last 6 months for homepage visits > 30 by month
n months ago	sales 2 months ago by region
last n months for each quarter	cost last 2 months for each quarter
last n months for each year	last 8 months for each year
n quarters ago	sales 4 quarters ago by product name contains deluxe
last n quarters for each year	last 2 quarters for each year
n weeks ago	sales 4 weeks ago by store
last n weeks for each month	sales last 3 weeks for each month
last n weeks for each quarter	last 2 weeks for each quarter
last n weeks for each year	last 3 weeks for each year
n years	opportunities next 5 years by revenue
n years ago	sales 5 years ago by store for region west
next day	shipments next day by order
next month	appointments next month by day
next n days	shipments next 7 days
next n months	openings next 6 months location
next n quarters	opportunities next 2 quarters by campaign
next n weeks	shipments next 10 weeks by day
next n years	projected deals next 5 years
next quarter	opportunities next quarter amount > 30000
next week	shipments next week by store
next year	opportunities next year by sales rep
quarter to date	sales by product quarter to date for top 10 products by sales
quarterly	sales quarterly for each product
quarterly year-over-year	growth of revenue by date shipped quarterly year-over-year
this day	shipments this day by order
this month	appointments this month by day
this quarter	opportunities this quarter amount > 30000
this week	shipments this week by store
this year	opportunities this year by sales rep
today	sales today by store
week	revenue by week last quarter
week to date	sales by order date week to date for pro-ski200
weekly	revenue weekly
weekly year-over-year	growth of revenue by date shipped weekly year-over-year
year	revenue by product 2014 product name contains snowboard
year to date	sales by product year to date
yearly	shipments by product yearly
yesterday	sales yesterday for pro-ski200 by store

Time

Keyword	Examples
detailed	ship time detailed
last hour	count unique visits last hour
last minute	count homepage views last minute
n hours	count visitors [ last \| next ] 12 hours
n hours ago	sum inventory by product by store 2 hours ago
n minutes	count visitors [ last \| next ] 30 minutes
n minutes ago	sum inventory by product 10 minutes ago
next hour	count projected visitors next hour
next minute	count projected visitors next minute
this hour	count visitors this hour
this minute	count visitors this minute

Text

Keyword	Examples
begins with	product name begins with 'pro' // returns all products that start with 'pro' product name begins with 'pro' product name begins with 'sport' // returns all products that start with 'pro' // OR 'sport' product name begins with 'pro' product color begins with 'bl' // returns all products that start with 'pro' // AND have color that starts with 'bl' (blue or black)
contains	product name contains "alpine" description contains "snow shoe"
ends with	product name ends with 'deluxe'
similar to	course name similar to 'hand'
not begins with	product name not begins with "tom's"
not contains	product color not contains 'tan' product color not contains 'red'
not ends with	product name not ends with "trial"
not similar to	course name not similar to 'hand'

Notes:

When more than one begins with or ends with keyword in a search or formula on the same column is used, results are returned using an OR condition.
When you use a combination of begins with and ends with, results are returned using the AND condition.
When using multiple begins with on different columns, results are returned using the AND condition.

For example, if you search for state name begins with "V" state name begins with "C", your results are: Virginia, Vermont, California, and Connecticut.

If you search for state name begins with V state name ends with T, your only result is Vermont.

Number

Keyword	Examples
average	average revenue by store
count	count visitors by site
max	max sales by visitor by site
min	min revenue by store by campaign for cost > 5000
standard deviation	standard deviation revenue by product by month for date after 10/31/2010
sum	sum revenue
unique count	unique count visitor by product page last week
variance	variance sale amount by visitor by product for last year

Comparative

Keyword	Examples
all	revenue asia vs all Note: The all keyword can only be used as part of a versus phrase.
between... and...	revenue between 0 and 1000
= (equal)	unique count visitor by store purchased products = 3 for last 5 days
everything	revenue asia vs everything Note: The everything keyword can only be used as part of a versus phrase.
> (greater than)	sum sale amount by visitor by product for last year sale amount > 2000
>= (greater than or equal)	count calls by employee lastname >= m
< (less than)	unique count visitor by product by store for sale amount < 20
<= (less than or equal)	count shipments by city latitude <= 0
!= (not equal)	sum sale amount region != canada date != last 5 days
vs, versus	revenue east vs west

You can use special constants for null and empty values with the = and != keywords: {null} and {empty}.

For example: customer name = {empty} or department != {null}.

Location

Keyword	Examples
farther than n miles\|km\|meters from …	average hours worked branch farther than 80 km from scarborough
near	revenue store name county near san francisco
near … within n miles\|km\|meters	revenue store name county near alameda within 50 miles

Period

Keyword	Examples
day	orders by day
day of month	sales day of month by month
day of quarter	deals day of quarter by year
day of week	customers by week day of week
day of year	ad clicks day of year by year
hour	visitors by hour weekly
month of quarter	purchases month of quarter by year
quarter	purchases by quarter
quarter of year	opportunities quarter of year last 4 years yearly
week of month	product shipments week of month yearly
week of quarter	revenue week of quarter
week of year	new products week of year last 3 years yearly

In / Not in

Keyword

Description

in

Query in query search (intersection of two sets). Must match last attribute before keyword with first attribute inside subsearch.

Syntax:

attribute in (attribute subsearch)

Examples:

store name in (top 10 store name by sales footwear)

product name 2014 product name in (product name 2013) sales

not in

Relative complement of two sets. Must match last attribute before keyword with first attribute inside subsearch.

Syntax:

attribute not in (attribute subsearch)

Example:

product name 2014 product name not in (product name 2013) sales
(= Find sales for all products ordered in 2014 that were not ordered in 2013)

Note: Searches with the in keyword do not include {null} values. To include {null} values, create a formula for the relevant attribute in your search, to convert {null} values to 'unknown,' or some similar word.