Deutsche keyword reference

Use keywords to help define a search.

  • This content is still under review, and may have incremental changes until this message is removed.

  • You can use keywords when asking a question to help define your search.

General

When using the top or bottom keywords without specifying a number (n), the number defaults to 10.
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
Deutsche

oben n

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
Deutsche

unten n

sort by

Sorts the result set by an attribute or measure.

Examples
revenue by state *sort by* average revenue

revenue by customer *sort by* region
Deutsche

sortieren nach

Date

after
Example
order date after 10/31/2014
Deutsche

nach

before
Example
order date before 03/01/2014
Deutsche

vor

between ... and ...
Example
order date between 01/30/2012 and 01/30/2014
Deutsche

zwischen … und …​

daily
Example
shipments by region daily
Deutsche

täglich

daily year-over-year
Example
growth of revenue by order date daily year-over-year
Deutsche

täglich vorjahresvergleich

day
Example
count monday restaurant
Deutsche

tag

day of week
Example
revenue by day of week last 6 months
Deutsche

wochentag

day of week
Example
count shipments Monday
Deutsche

wochentag

growth of …​ by ...
Example
growth of sales by order date
Deutsche

wachstum von … von…​

growth of …​ by …​ daily
Example
growth of sales by order date daily
Deutsche

wachstum von … von…​ täglich

growth of …​ by …​ monthly
Example
growth of sales by date shipped monthly sales > 24000
Deutsche

wachstum von … von … monatlich

growth of …​ by …​ quarterly
Example
growth of sales by date shipped quarterly
Deutsche

wachstum von … von … vierteljährlich

growth of …​ by …​ weekly
Example
growth of sales by receipt date weekly for pro-ski2000
Deutsche

wachstum von … von … wöchentlich

growth of …​ by …​ yearly
Example
growth of sales by date closed yearly
Deutsche

wachstum von … von … jährlich

hourly
Example
visitors by page name hourly
Deutsche

stündlich

last day by
Example
customers last day by referrer
Deutsche

letzte tag von

last month by
Example
customers last month by day
Deutsche

letzte monat von

last n days
Example
visitors last 7 days
Deutsche

letzte n tage

last n quarters
Example
visitors last 2 quarters by month by campaign
Deutsche

letzte n quartale

last n weeks
Example
visitors last 10 weeks by day
Deutsche

letzte n wochen

last n years
Example
visitors last 5 years by revenue for sum revenue > 5000
Deutsche

letzte n jahre

last quarter
Example
customers last quarter sale > 300
Deutsche

letzte quartal

last week
Example
customers last week by store
Deutsche

letzte woche

last year
Example
top 10 customers last year by sale by store for region west
Deutsche

letzte jahr

month
Example
revenue by month last year
Deutsche

monat

month
Example
commission January
Deutsche

monat

month to date
Example
sales by product month to date sales > 2400
Deutsche

monat bis jetzt

month year
Example
commission by sales rep February 2014
Deutsche

monat jahr

monthly
Example
commission > 10000 monthly
Deutsche

monatlich

monthly year-over-year
Example
growth of revenue
  by receipt date
  monthly year-over-year
Deutsche

monatlich vorjahresvergleich

n days ago
Example
sales 2 days ago
Deutsche

n tage vor

n days for each month
Example
sales last 2 days for each month
Deutsche

n tage für jeden monat

n days for each quarter
Example
revenue last 15 days for each quarter
Deutsche

n tage für jeden quartal

n days for each week
Example
total sold last 2 days for each week
Deutsche

n tage für jeden woche

n days for each year
Example
revenue last 300 days for each year
Deutsche

n tage für jeden jahr

n hours for each day
Example
sales last 2 hours for each day
Deutsche

n stündlich für jeden tag

n months
Example
visitors last 6 months for homepage visits > 30 by month
Deutsche

n monate

n months ago
Example
sales 2 months ago by region
Deutsche

n monate vor

n months for each quarter
Example
cost last 2 months for each quarter
Deutsche

n monate für jeden quartal

n months for each year
Example
last 8 months for each year
Deutsche

n monate für jeden jahr

n quarters ago
Example
sales 4 quarters ago by product name contains deluxe
Deutsche

n tage vor

n quarters for each year
Example
last 2 quarters for each year
Deutsche

n quartale für jeden jahr

n weeks ago
Example
sales 4 weeks ago by store
Deutsche

n wochen vor

n weeks for each month
Example
sales last 3 weeks for each month
Deutsche

n wochen für jeden monat

n weeks for each quarter
Example
last 2 weeks for each quarter
Deutsche

n wochen für jeden quartal

n weeks for each year
Example
last 3 weeks for each year
Deutsche

n wochen für jeden jahr

n years
Example
opportunities next 5 years by revenue
Deutsche

n jahre

n years ago
Example
sales 5 years ago by store for region west
Deutsche

n jahre vor

next day
Example
shipments next day by order
Deutsche

nächste tag

next month
Example
appointments next month by day
Deutsche

nächste monat

next n days
Example
shipments next 7 days
Deutsche

nächste n tag

next n months
Example
openings next 6 months location
Deutsche

nächste n monate

next n quarters
Example
opportunities next 2 quarters by campaign
Deutsche

nächste n quartale

next n weeks
Example
shipments next 10 weeks by day
Deutsche

nächste n wochen

next quarter
Example
opportunities next quarter amount > 30000
Deutsche

nächste quartal

next week
Example
shipments next week by store
Deutsche

nächste woche

next year
Example
opportunities next year by sales rep
Deutsche

nächste jahr

quarter to date
Example
sales by product quarter to date
  for top 10 products by sales
Deutsche

quartal bis jetzt

quarterly
Example
sales quarterly for each product
Deutsche

quartale

quarterly year-over-year
Example
growth of revenue by date shipped
quarterly year-over-year
Deutsche

quartale vorjahresvergleich

today
Example
sales today by store
Deutsche

heute

week
Example
revenue by week last quarter
Deutsche

woche

week to date
Example
sales by order date week to date for pro-ski200
Deutsche

woche bis jetzt

weekly
Example
revenue weekly
Deutsche

wöchentlich

weekly year-over-year
Example
growth of revenue by date shipped
  weekly year-over-year
Deutsche

wöchentlich vorjahresvergleich

year
Example
revenue by product 2014 product name contains snowboard
Deutsche

jahr

year to date
Example
sales by product year to date
Deutsche

jahr bis jetzt

yearly
Example
shipments by product yearly
Deutsche

jährlich

yesterday
Example
sales yesterday for pro-ski200 by store
Deutsche

gestern

Time

Text

Number

average
Example
average revenue by store
Deutsche

durchschnitt

count
Example
count visitors by site
Deutsche

anzahl

max
Example
max sales by visitor by site
Deutsche

maximum

min
Example
min revenue by store by campaign for cost > 5000
Deutsche

minimum

standard deviation
Example
standard deviation revenue by product by month for date after
10/31/2010
Deutsche

standardabweichung

sum
Example
sum revenue
Deutsche

summe

unique count
Example
unique count visitor by product page last week
Deutsche

eindeutige anzahl

variance
Example
variance sale amount by visitor by product for last year
Deutsche

varianz

Comparative

all
Example
all orders
Deutsche

alle

between... and...
Example
revenue between 0 and 1000
Deutsche

zwischen … und

= (equal)
Example
unique count visitor by store purchased products = 3 for last 5
days
Deutsche

=

> (greater than)
Example
sum sale amount by visitor by product for last year sale amount > 2000
Deutsche

>

>= (greater than or equal)
Example
count calls by employee lastname >= m
Deutsche

>=

< (less than)
Example
unique count visitor by product by store for sale amount < 20
Deutsche

<

<= (less than or equal)
Example
count shipments by city latitude <= 0
Deutsche

!= (not equal)
Example
sum sale amount region != canada date != last 5 days
Deutsche

!=

vs, versus
Example
revenue east vs west
Deutsche

vs, versus

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

Location keywords only work for searches where the data source includes latitude/longitude data.
farther than n miles|km|meters from …​
Example
average hours worked branch farther than 80 km from scarborough
Deutsche

entfernter als n meilen|km|meter

near
Example
revenue store name county near san francisco
Deutsche

nahe

near …​ within n miles|km|meters
Example
revenue store name county near alameda within 50 miles
Deutsche

nahe …​ innerhalb n meilen|km|meter

Period

day
Example
orders by day
Deutsche

tag (date)

day of month
Example
sales day of month by month
Deutsche

tag des monats (date)

day of quarter
Example
deals day of quarter by year
Deutsche

tag des quartals (date)

day of week
Example
customers by week day of week
Deutsche

wochentag (date)

day of year
Example
ad clicks day of year by year
Deutsche

tag des jahres (date)

hour
Example
visitors by hour weekly
Deutsche

stunde (datetime)

month of quarter
Example
purchases month of quarter by year
Deutsche

monat des quartals (date)

quarter
Example
purchases by quarter
Deutsche

quartal (date)

quarter of year
Example
opportunities quarter of year last 4 years yearly
Deutsche

quartal des jahres (date)

week of month
Example
product shipments week of month yearly
Deutsche

woche des monats (date)

week of quarter
Example
revenue week of quarter
Deutsche

woche des quartals (date)

week of year
Example
new products week of year last 3 years yearly
Deutsche

woche des jahres (date)