Dansk 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
- 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.- 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
- 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
- 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. - 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}.
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
- 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
- Dansk
-
uge af måned (date)
- week of quarter
-
- Example
-
revenue week of quarter
- Dansk
-
uge i kvartal (date)
- week of year
-
- Example
-
new products week of year last 3 years yearly
- Dansk
-
uge af år (date)
Was this page helpful?Give us feedback!
