Dansk keyword reference
Use keywords to help define a search.
Note that you can only use one set of keywords at a time. If you set your locale to Dansk, you can only use Dansk keywords. You can’t also use English keywords, or any other language. ThoughtSpot doesn’t translate its branded terms, such as SpotIQ.
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. If your search has more than 1 measure, ThoughtSpot generates the top n items from the first measure in the search.
- Examples
-
top 10 sales rep revenue top sales rep by count sales for average revenue > 10000 sales rep average revenue for each region top
- Dansk
-
top 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
- Dansk
-
top n efter
- top n … ranked by
-
Ranks the top n items by a specified measure. The
ranked bykeyword only works in conjunction with thetopkeyword. If your search has more than 1 measure, ThoughtSpot generates the top n items from the first measure in the search.- Examples
-
top 10 sales rep revenue sales ranked by sales top customer revenue generated # of ads clicked ranked by # of ads clicked
- Dansk
-
top n … rangeret i forhold til
- 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
- Dansk
-
bund 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
- Dansk
-
sorter efter
- by <measure>
-
Treats the measure as an attribute and groups the result set by it.
- Examples
-
cost by revenue product by quantity purchased
- Dansk
-
efter
Date
The last keyword returns the last n full periods and does not include the current period. For example, last 6 hours returns the last 6 full hours and does not include the current hour. To include the current period, add this <period>. For example, last 6 hours this hour.
|
- after
-
- Example
-
order date after 10/31/2014
- Dansk
-
efter
- before
-
- Example
-
order date before 03/01/2014
- Dansk
-
før
- between ... and ...
-
- Example
-
order date between 01/30/2012 and 01/30/2014
- Dansk
-
mellem … og …
- daily
-
- Example
-
shipments by region daily
- Dansk
-
daglig
- daily year-over-year
-
- Example
-
growth of revenue by order date daily year-over-year
- Dansk
-
daglig år-over-år
- day
-
- Example
-
count monday restaurant
- Dansk
-
dag
- day of week
-
- Example
-
revenue by day of week last 6 months
- Dansk
-
ugedag
- day of week
-
- Example
-
count shipments Monday
- Dansk
-
ugedag
- growth of … by ...
-
- Example
-
growth of sales by order date
- Dansk
-
vækst af … ved …
- growth of … by … daily
-
- Example
-
growth of sales by order date daily
- Dansk
-
vækst af … ved … daglig
- growth of … by … monthly
-
- Example
-
growth of sales by date shipped monthly sales > 24000
- Dansk
-
vækst af … ved … månedlig
- growth of … by … quarterly
-
- Example
-
growth of sales by date shipped quarterly
- Dansk
-
vækst af … ved … kvartalsvis
- growth of … by … weekly
-
- Example
-
growth of sales by receipt date weekly for pro-ski2000
- Dansk
-
vækst af … ved … ugentlig
- growth of … by … yearly
-
- Example
-
growth of sales by date closed yearly
- Dansk
-
vækst af … ved … årligt
- hourly
-
- Example
-
visitors by page name hourly
- Dansk
-
time
- last day by
-
- Example
-
customers last day by referrer
- Dansk
-
sidst dag ved
- last month by
-
- Example
-
customers last month by day
- Dansk
-
sidst måned ved
- last n days
-
- Example
-
visitors last 7 days
- Dansk
-
sidst n dage
- last n quarters
-
- Example
-
visitors last 2 quarters by month by campaign
- Dansk
-
sidst n kvartaler
- last n weeks
-
- Example
-
visitors last 10 weeks by day
- Dansk
-
sidst n dage
- last n years
-
- Example
-
visitors last 5 years by revenue for sum revenue > 5000
- Dansk
-
sidst n år
- last quarter
-
- Example
-
customers last quarter sale > 300
- Dansk
-
sidst kvartal
- last year
-
- Example
-
top 10 customers last year by sale by store for region west
- Dansk
-
sidst år
- last week
-
- Example
-
customers last week by store
- Dansk
-
sidst uge
- month
-
- Example
-
revenue by month last year
- Dansk
-
måned
- month
-
- Example
-
commission January
- Dansk
-
måned
- month to date
-
- Example
-
sales by product month to date sales > 2400
- Dansk
-
måned til dato
- month year
-
- Example
-
commission by sales rep February 2014
- Dansk
-
måned år
- monthly
-
- Example
-
commission > 10000 monthly
- Dansk
-
månedlig
- monthly year-over-year
-
- Example
-
growth of revenue by receipt date monthly year-over-year
- Dansk
-
månedlig år-over-år
- n days ago
-
- Example
-
sales 2 days ago
- Dansk
-
n dage siden
- last n days for each month
-
- Example
-
sales last 2 days for each month
- Dansk
-
n dage for hver måned
- last n days for each quarter
-
- Example
-
revenue last 15 days for each quarter
- Dansk
-
n dage for hver kvartal
- last n days for each week
-
- Example
-
total sold last 2 days for each week
- Dansk
-
n dage for hver uge
- last n days for each year
-
- Example
-
revenue last 300 days for each year
- Dansk
-
n dage for hver år
- last n hours for each day
-
- Example
-
sales last 2 hours for each day
- Dansk
-
n timer for hver dag
- n months
-
- Example
-
visitors last 6 months for homepage visits > 30 by month
- Dansk
-
n måneder
- n months ago
-
- Example
-
sales 2 months ago by region
- Dansk
-
n måneder siden
- last n months for each quarter
-
- Example
-
cost last 2 months for each quarter
- Dansk
-
n måneder for hver kvartal
- last n months for each year
-
- Example
-
last 8 months for each year
- Dansk
-
n måneder for hver år
- n quarters ago
-
- Example
-
sales 4 quarters ago by product name contains deluxe
- Dansk
-
n kvartaler siden
- last n quarters for each year
-
- Example
-
last 2 quarters for each year
- Dansk
-
n kvartaler for hver år
- n weeks ago
-
- Example
-
sales 4 weeks ago by store
- Dansk
-
n uger siden
- last n weeks for each month
-
- Example
-
sales last 3 weeks for each month
- Dansk
-
n uger for hver måned
- last n weeks for each quarter
-
- Example
-
last 2 weeks for each quarter
- Dansk
-
n uger for hver kvartal
- last n weeks for each year
-
- Example
-
last 3 weeks for each year
- Dansk
-
n uger for hver år
- n years
-
- Example
-
opportunities next 5 years by revenue
- Dansk
-
n år
- n years ago
-
- Example
-
sales 5 years ago by store for region west
- Dansk
-
n år siden
- next day
-
- Example
-
shipments next day by order
- Dansk
-
næste dag
- next month
-
- Example
-
appointments next month by day
- Dansk
-
næste måned
- next n days
-
- Example
-
shipments next 7 days
- Dansk
-
næste n dage
- next n months
-
- Example
-
openings next 6 months location
- Dansk
-
næste n måneder
- next n quarters
-
- Example
-
opportunities next 2 quarters by campaign
- Dansk
-
næste n kvartaler
- next n weeks
-
- Example
-
shipments next 10 weeks by day
- Dansk
-
næste n uger
- next quarter
-
- Example
-
opportunities next quarter amount > 30000
- Dansk
-
næste kvartal
- next week
-
- Example
-
shipments next week by store
- Dansk
-
næste uge
- next year
-
- Example
-
opportunities next year by sales rep
- Dansk
-
næste år
- quarter to date
-
- Example
-
sales by product quarter to date for top 10 products by sales
- Dansk
-
kvartal til dato
- quarterly
-
- Example
-
sales quarterly for each product
- Dansk
-
kvartalsvis
- quarterly year-over-year
-
- Example
-
growth of revenue by date shipped quarterly year-over-year
- Dansk
-
kvartalsvis år-over-år
- this day
-
- Example
-
shipments this day by order
- Dansk
-
dette dag
- this month
-
- Example
-
appointments this month by day
- Dansk
-
dette måned
- this quarter
-
- Example
-
opportunities this quarter amount > 30000
- Dansk
-
dette kvartal
- this week
-
- Example
-
shipments this week by store
- Dansk
-
dette uge
- this year
-
- Example
-
opportunities this year by sales rep
- Dansk
-
dette år
- today
-
- Example
-
sales today by store
- Dansk
-
i dag
- week
-
- Example
-
revenue by week last quarter
- Dansk
-
uge
- week to date
-
- Example
-
sales by order date week to date for pro-ski200
- Dansk
-
uge til dato
- weekly
-
- Example
-
revenue weekly
- Dansk
-
ugentlig
- weekly year-over-year
-
- Example
-
growth of revenue by date shipped weekly year-over-year
- Dansk
-
ugentlig år-over-år
- year
-
- Example
-
revenue by product 2014 product name contains snowboard
- Dansk
-
år
- year to date
-
- Example
-
sales by product year to date
- Dansk
-
år til dato
- yearly
-
- Example
-
shipments by product yearly
- Dansk
-
årligt
- yesterday
-
- Example
-
sales yesterday for pro-ski200 by store
- Dansk
-
i går
Time
The last keyword returns the last n full periods and does not include the current period. For example, last 6 hours returns the last 6 full hours and does not include the current hour. To include the current period, add this <period>. For example, last 6 hours this hour.
|
- detailed
-
- Example
-
ship time detailed
- Dansk
-
detaljeret
- last hour
-
- Example
-
count unique visits last hour
- Dansk
-
sidst time
- last minute
-
- Example
-
count homepage views last minute
- Dansk
-
sidst minut
- n hours
-
- Example
-
count visitors [ last | next ] 12 hours
- Dansk
-
n timer
- n hours ago
-
- Example
-
sum inventory by product by store 2 hours ago
- Dansk
-
n timer siden
- n minutes
-
- Example
-
count visitors [ last | next ] 30 minutes
- Dansk
-
n minutter
- n minutes ago
-
- Example
-
sum inventory by product 10 minutes ago
- Dansk
-
n minutter siden
Text
- begins with Update
-
- Examples
-
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)
- Dansk
-
begynder med
- contains
-
- Example
-
product name contains "alpine" description contains "snow shoe"
- Dansk
-
indeholder
- ends with
-
- Example
-
product name ends with 'deluxe'
- Dansk
-
ender med
- similar to
-
- Example
-
course name similar to 'hand'
- Dansk
-
svarende til
- not begins with
-
- Example
-
product name not begins with "tom's"
- Dansk
-
begynder ikke med
- not contains
-
- Example
-
product color not contains 'tan' product color not contains 'red'
- Dansk
-
indeholder ikke
- not ends with
-
- Example
-
product name not ends with "trial"
- Dansk
-
ender ikke med
- not similar to
-
- Example
-
course name not similar to 'hand'
- Dansk
-
ikke svarende til
Number
- average
-
- Example
-
average revenue by store
- Dansk
-
gennemsnit
- count
-
- Example
-
count visitors by site
- Dansk
-
optælling
- max
-
- Example
-
max sales by visitor by site
- Dansk
-
maks
- min
-
- Example
-
min revenue by store by campaign for cost > 5000
- Dansk
-
min
- standard deviation
-
- Example
-
standard deviation revenue by product by month for date after 10/31/2010
- Dansk
-
standardafvigelse
- sum
-
- Example
-
sum revenue
- Dansk
-
sum
- unique count
-
- Example
-
unique count visitor by product page last week
- Dansk
-
unik optælling
- variance
-
- Example
-
variance sale amount by visitor by product for last year
- Dansk
-
varians
Comparative
all-
- Example
-
revenue asia vs all
The allkeyword can only be used as part of a versus phrase. - Dansk
-
alle
between... and...-
- Example
-
revenue between 0 and 1000
- Dansk
-
mellem … og
=(equal)-
- Example
-
unique count visitor by store purchased products = 3 for last 5 days
- Dansk
-
=
everything-
- Example
-
revenue asia vs everything
The everythingkeyword can only be used as part of a versus phrase. - Dansk
-
alt
>(greater than)-
- Example
-
sum sale amount by visitor by product for last year sale amount > 2000
- Dansk
-
>
>=(greater than or equal)-
- Example
-
count calls by employee lastname >= m
- Dansk
-
>=
<(less than)-
- Example
-
unique count visitor by product by store for sale amount < 20
- Dansk
-
<
<=(less than or equal)-
- Example
-
count shipments by city latitude <= 0
- Dansk
-
⇐
!=(not equal)-
- Example
-
sum sale amount region != canada date != last 5 days
- Dansk
-
!=
vs,versus-
- Example
-
revenue east vs west
ThoughtSpot does not support the use of group_* formula measures with the vskeyword. ThoughtSpot doesn’t support the use of thevskeyword within aninornot insubquery. - Dansk
-
vs, mod
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}. NULL values are missing or invalid (for example, dividing by 0) values. ThoughtSpot also shows NULL if you have n/a in your data. Empty values are empty strings of text or strings containing only whitespace (spaces, tabs).
Location
- farther than n miles|km|meters from …
-
- Example
-
average hours worked branch farther than 80 km from scarborough
- Dansk
-
længere end inden for n mil|km|meter fra
- near
-
- Example
-
revenue store name county near san francisco
- Dansk
-
nær ved
- near … within n miles|km|meters
-
- Example
-
revenue store name county near alameda within 50 miles
- Dansk
-
nær ved inden for n mil|km|meter
Period
- day
-
- Example
-
orders by day
- Dansk
-
dag (date)
- day of month
-
- Example
-
sales day of month by month
- Dansk
-
dag i måned (date)
- day of quarter
-
- Example
-
deals day of quarter by year
- Dansk
-
dag i kvartal (date)
- day of week
-
- Example
-
customers by week day of week
- Dansk
-
ugedag (date)
- day of year
-
- Example
-
ad clicks day of year by year
- Dansk
-
dag af år (date)
- hour
-
- Example
-
visitors by hour weekly
- Dansk
-
time (datetime)
- month of quarter
-
- Example
-
purchases month of quarter by year
- Dansk
-
måned i kvartal (date)
- quarter
-
- Example
-
purchases by quarter
- Dansk
-
kvartal (date)
- quarter of year
-
- Example
-
opportunities quarter of year last 4 years yearly
- Dansk
-
kvartal af år (date)
- week of month
-
- Example
-
product shipments week of month yearly
ThoughtSpot uses ISO week format for the week of [month | quarter | year]keywords, which means that the last few days of a quarter may sometimes show as the first few days of the next quarter, based on the ISO week date system. - Dansk
-
uge af måned (date)
- week of quarter
-
- Example
-
revenue week of quarter
ThoughtSpot uses ISO week format for the week of [month | quarter | year]keywords, which means that the last few days of a quarter may sometimes show as the first few days of the next quarter, based on the ISO week date system. - Dansk
-
uge i kvartal (date)
- week of year
-
- Example
-
new products week of year last 3 years yearly
ThoughtSpot uses ISO week format for the week of [month | quarter | year]keywords, which means that the last few days of a quarter may sometimes show as the first few days of the next quarter, based on the ISO week date system. - Dansk
-
uge af år (date)
