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 | Description |
---|---|
after | Example: order date after 10/31/2014 |
before | Example: order date before 03/01/2014 |
between ... and ... | Example: order date between 01/30/2012 and 01/30/2014 |
daily | Example: shipments by region daily |
daily year-over-year | Example: growth of revenue by order date daily year-over-year |
day | Example: count monday restaurant |
day of week | Examples: revenue by day of week last 6 months |
growth of … by ... | Example: growth of sales by order date |
growth of … by … daily | Example: growth of sales by order date daily |
growth of … by … monthly | Example: growth of sales by date shipped monthly sales > 24000 |
growth of … by … quarterly | Example: growth of sales by date shipped quarterly |
growth of … by … weekly | Example: growth of sales by receipt date weekly for pro-ski2000 |
hourly | Example: visitors by page name hourly |
last day by | Example: customers last day by referrer |
last month | Example: customers last month by store |
last month by | Example: customers last month by day |
last n days | Example: visitors last 7 days |
last n months | Example: visitors last 10 months by day |
last n quarters | Example: visitors last 2 quarters by month by campaign |
last n weeks | Example: visitors last 10 weeks by day |
last n years | Example: visitors last 5 years by revenue for sum revenue > 5000 |
last quarter | Example: customers last quarter sale > 300 |
last week | Example: customers last week by store |
last year | Example: top 10 customers last year by sale by store for region west |
month | Example: revenue by month last year |
month | Example: commission January |
month to date | Example: sales by product month to date sales > 2400 |
month year | Example: commission by sales rep February 2014 |
monthly | Example: commission > 10000 monthly |
monthly year-over-year | Example: growth of revenue by receipt date monthly year-over-year |
n days ago | Example: sales 2 days ago |
last n days for each month | Example: sales last 2 days for each month |
last n days for each quarter | Example: revenue last 15 days for each quarter |
last n days for each week | Example: total sold last 2 days for each week |
last n days for each year | Example: revenue last 300 days for each year |
last n hours for each day | Example: sales last 2 hours for each day |
n months | Example: visitors last 6 months for homepage visits > 30 by month |
n months ago | Example: sales 2 months ago by region |
last n months for each quarter | Example: cost last 2 months for each quarter |