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 |