Deutsch keyword reference
Use keywords to help define a 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
- Deutsch
-
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
- Deutsch
-
unten n
- 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
- Deutsch
-
sortieren nach
Date
- after
-
- Example
-
order date after 10/31/2014
- Deutsch
-
nach
- before
-
- Example
-
order date before 03/01/2014
- Deutsch
-
vor
- between ... and ...
-
- Example
-
order date between 01/30/2012 and 01/30/2014
- Deutsch
-
zwischen … und …
- daily
-
- Example
-
shipments by region daily
- Deutsch
-
täglich
- daily year-over-year
-
- Example
-
growth of revenue by order date daily year-over-year
- Deutsch
-
täglich vorjahresvergleich
- day
-
- Example
-
count monday restaurant
- Deutsch
-
tag
- day of week
-
- Example
-
revenue by day of week last 6 months
- Deutsch
-
wochentag
- day of week
-
- Example
-
count shipments Monday
- Deutsch
-
wochentag
- growth of … by ...
-
- Example
-
growth of sales by order date
- Deutsch
-
wachstum von … von…
- growth of … by … daily
-
- Example
-
growth of sales by order date daily
- Deutsch
-
wachstum von … von… täglich
- growth of … by … monthly
-
- Example
-
growth of sales by date shipped monthly sales > 24000
- Deutsch
-
wachstum von … von … monatlich
- growth of … by … quarterly
-
- Example
-
growth of sales by date shipped quarterly
- Deutsch
-
wachstum von … von … vierteljährlich
- growth of … by … weekly
-
- Example
-
growth of sales by receipt date weekly for pro-ski2000
- Deutsch
-
wachstum von … von … wöchentlich
- growth of … by … yearly
-
- Example
-
growth of sales by date closed yearly
- Deutsch
-
wachstum von … von … jährlich
- hourly
-
- Example
-
visitors by page name hourly
- Deutsch
-
stündlich
- last day by
-
- Example
-
customers last day by referrer
- Deutsch
-
letzte tag von
- last month by
-
- Example
-
customers last month by day
- Deutsch
-
letzte monat von
- last n days
-
- Example
-
visitors last 7 days
- Deutsch
-
letzte n tage
- last n quarters
-
- Example
-
visitors last 2 quarters by month by campaign
- Deutsch
-
letzte n quartale
- last n weeks
-
- Example
-
visitors last 10 weeks by day
- Deutsch
-
letzte n wochen
- last n years
-
- Example
-
visitors last 5 years by revenue for sum revenue > 5000
- Deutsch
-
letzte n jahre
- last quarter
-
- Example
-
customers last quarter sale > 300
- Deutsch
-
letzte quartal
- last week
-
- Example
-
customers last week by store
- Deutsch
-
letzte woche
- last year
-
- Example
-
top 10 customers last year by sale by store for region west
- Deutsch
-
letzte jahr
- month
-
- Example
-
revenue by month last year
- Deutsch
-
monat
- month
-
- Example
-
commission January
- Deutsch
-
monat
- month to date
-
- Example
-
sales by product month to date sales > 2400
- Deutsch
-
monat bis jetzt
- month year
-
- Example
-
commission by sales rep February 2014
- Deutsch
-
monat jahr
- monthly
-
- Example
-
commission > 10000 monthly
- Deutsch
-
monatlich
- monthly year-over-year
-
- Example
-
growth of revenue by receipt date monthly year-over-year
- Deutsch
-
monatlich vorjahresvergleich
- n days ago
-
- Example
-
sales 2 days ago
- Deutsch
-
n tage vor
- last n days for each month
-
- Example
-
sales last 2 days for each month
- Deutsch
-
n tage für jeden monat
- last n days for each quarter
-
- Example
-
revenue last 15 days for each quarter
- Deutsch
-
n tage für jeden quartal
- last n days for each week
-
- Example
-
total sold last 2 days for each week
- Deutsch
-
n tage für jeden woche
- last n days for each year
-
- Example
-
revenue last 300 days for each year
- Deutsch
-
n tage für jeden jahr
- last n hours for each day
-
- Example
-
sales last 2 hours for each day
- Deutsch
-
n stündlich für jeden tag
- n months
-
- Example
-
visitors last 6 months for homepage visits > 30 by month
- Deutsch
-
n monate
- n months ago
-
- Example
-
sales 2 months ago by region
- Deutsch
-
n monate vor
- last n months for each quarter
-
- Example
-
cost last 2 months for each quarter
- Deutsch
-
n monate für jeden quartal
- last n months for each year
-
- Example
-
last 8 months for each year
- Deutsch
-
n monate für jeden jahr
- n quarters ago
-
- Example
-
sales 4 quarters ago by product name contains deluxe
- Deutsch
-
n tage vor
- last n quarters for each year
-
- Example
-
last 2 quarters for each year
- Deutsch
-
n quartale für jeden jahr
- n weeks ago
-
- Example
-
sales 4 weeks ago by store
- Deutsch
-
n wochen vor
- last n weeks for each month
-
- Example
-
sales last 3 weeks for each month
- Deutsch
-
n wochen für jeden monat
- last n weeks for each quarter
-
- Example
-
last 2 weeks for each quarter
- Deutsch
-
n wochen für jeden quartal
- last n weeks for each year
-
- Example
-
last 3 weeks for each year
- Deutsch
-
n wochen für jeden jahr
- n years
-
- Example
-
opportunities next 5 years by revenue
- Deutsch
-
n jahre
- n years ago
-
- Example
-
sales 5 years ago by store for region west
- Deutsch
-
n jahre vor
- next day
-
- Example
-
shipments next day by order
- Deutsch
-
nächste tag
- next month
-
- Example
-
appointments next month by day
- Deutsch
-
nächste monat
- next n days
-
- Example
-
shipments next 7 days
- Deutsch
-
nächste n tag
- next n months
-
- Example
-
openings next 6 months location
- Deutsch
-
nächste n monate
- next n quarters
-
- Example
-
opportunities next 2 quarters by campaign
- Deutsch
-
nächste n quartale
- next n weeks
-
- Example
-
shipments next 10 weeks by day
- Deutsch
-
nächste n wochen
- next quarter
-
- Example
-
opportunities next quarter amount > 30000
- Deutsch
-
nächste quartal
- next week
-
- Example
-
shipments next week by store
- Deutsch
-
nächste woche
- next year
-
- Example
-
opportunities next year by sales rep
- Deutsch
-
nächste jahr
- quarter to date
-
- Example
-
sales by product quarter to date for top 10 products by sales
- Deutsch
-
quartal bis jetzt
- quarterly
-
- Example
-
sales quarterly for each product
- Deutsch
-
quartale
- quarterly year-over-year
-
- Example
-
growth of revenue by date shipped quarterly year-over-year
- Deutsch
-
quartale vorjahresvergleich
- today
-
- Example
-
sales today by store
- Deutsch
-
heute
- week
-
- Example
-
revenue by week last quarter
- Deutsch
-
woche
- week to date
-
- Example
-
sales by order date week to date for pro-ski200
- Deutsch
-
woche bis jetzt
- weekly
-
- Example
-
revenue weekly
- Deutsch
-
wöchentlich
- weekly year-over-year
-
- Example
-
growth of revenue by date shipped weekly year-over-year
- Deutsch
-
wöchentlich vorjahresvergleich
- year
-
- Example
-
revenue by product 2014 product name contains snowboard
- Deutsch
-
jahr
- year to date
-
- Example
-
sales by product year to date
- Deutsch
-
jahr bis jetzt
- yearly
-
- Example
-
shipments by product yearly
- Deutsch
-
jährlich
- yesterday
-
- Example
-
sales yesterday for pro-ski200 by store
- Deutsch
-
gestern
Number
- average
-
- Example
-
average revenue by store
- Deutsch
-
durchschnitt
- count
-
- Example
-
count visitors by site
- Deutsch
-
anzahl
- max
-
- Example
-
max sales by visitor by site
- Deutsch
-
maximum
- min
-
- Example
-
min revenue by store by campaign for cost > 5000
- Deutsch
-
minimum
- standard deviation
-
- Example
-
standard deviation revenue by product by month for date after 10/31/2010
- Deutsch
-
standardabweichung
- sum
-
- Example
-
sum revenue
- Deutsch
-
summe
- unique count
-
- Example
-
unique count visitor by product page last week
- Deutsch
-
eindeutige anzahl
- variance
-
- Example
-
variance sale amount by visitor by product for last year
- Deutsch
-
varianz
Comparative
all
-
- Example
-
revenue asia vs all
The all
keyword can only be used as part of a versus phrase. - Deutsch
-
alle
between... and...
-
- Example
-
revenue between 0 and 1000
- Deutsch
-
zwischen … und
=
(equal)-
- Example
-
unique count visitor by store purchased products = 3 for last 5 days
- Deutsch
-
=
everything
-
- Example
-
revenue asia vs everything
The everything
keyword can only be used as part of a versus phrase. - Deutsch
-
alles
>
(greater than)-
- Example
-
sum sale amount by visitor by product for last year sale amount > 2000
- Deutsch
-
>
>=
(greater than or equal)-
- Example
-
count calls by employee lastname >= m
- Deutsch
-
>=
<
(less than)-
- Example
-
unique count visitor by product by store for sale amount < 20
- Deutsch
-
<
<=
(less than or equal)-
- Example
-
count shipments by city latitude <= 0
- Deutsch
-
⇐
!=
(not equal)-
- Example
-
sum sale amount region != canada date != last 5 days
- Deutsch
-
!=
vs
,versus
-
- Example
-
revenue east vs west
- Deutsch
-
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. You can only use them if you bring your data into ThoughtSpot’s in-memory database. You cannot use these keywords if you connect to your data in an external database. |
- farther than n miles|km|meters from …
-
- Example
-
average hours worked branch farther than 80 km from scarborough
- Deutsch
-
entfernter als n meilen|km|meter
- near
-
- Example
-
revenue store name county near san francisco
- Deutsch
-
nahe
- near … within n miles|km|meters
-
- Example
-
revenue store name county near alameda within 50 miles
- Deutsch
-
nahe … innerhalb n meilen|km|meter
Period
- day
-
- Example
-
orders by day
- Deutsch
-
tag (date)
- day of month
-
- Example
-
sales day of month by month
- Deutsch
-
tag des monats (date)
- day of quarter
-
- Example
-
deals day of quarter by year
- Deutsch
-
tag des quartals (date)
- day of week
-
- Example
-
customers by week day of week
- Deutsch
-
wochentag (date)
- day of year
-
- Example
-
ad clicks day of year by year
- Deutsch
-
tag des jahres (date)
- hour
-
- Example
-
visitors by hour weekly
- Deutsch
-
stunde (datetime)
- month of quarter
-
- Example
-
purchases month of quarter by year
- Deutsch
-
monat des quartals (date)
- quarter
-
- Example
-
purchases by quarter
- Deutsch
-
quartal (date)
- quarter of year
-
- Example
-
opportunities quarter of year last 4 years yearly
- Deutsch
-
quartal des jahres (date)
- week of month
-
- Example
-
product shipments week of month yearly
- Deutsch
-
woche des monats (date)
- week of quarter
-
- Example
-
revenue week of quarter
- Deutsch
-
woche des quartals (date)
- week of year
-
- Example
-
new products week of year last 3 years yearly
- Deutsch
-
woche des jahres (date)