Suomi 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
Suomi

ylös 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
Suomi

ylös n mukaan

top n …​ ranked by

Ranks the top n items by a specified measure. The ranked by keyword only works in conjunction with the top keyword.

Examples
top 10 sales rep revenue sales ranked by sales

top customer revenue generated # of ads clicked ranked by # of ads clicked
Suomi

ylös n …​ lajiteltu

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
Suomi

alas 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
Suomi

lajittele mukaan

by <measure>

Treats the measure as an attribute and groups the result set by it.

Examples
cost by revenue

product by quantity purchased
Suomi

mukaan

Date

after
Example
order date after 10/31/2014
Suomi

jälkeen

before
Example
order date before 03/01/2014
Suomi

ennen

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

välillä … ja …

daily
Example
shipments by region daily
Suomi

päivittäin

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

päivittäin vuosivertailu

day
Example
count monday restaurant
Suomi

päivä

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

viikonpäivä

day of week
Example
count shipments Monday
Suomi

viikonpäivä

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

kasvu … mukaan …

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

kasvu … mukaan … päivittäin

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

kasvu … mukaan … kuukausittain

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

kasvu … mukaan … vuosineljännes

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

kasvu … mukaan … viikoittain

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

kasvu … mukaan … vuosittain

hourly
Example
visitors by page name hourly
Suomi

tunneittain

last day by
Example
customers last day by referrer
Suomi

viimeinen päivä mukaan

last month by
Example
customers last month by day
Suomi

viimeinen kuukausi mukaan

last n days
Example
visitors last 7 days
Suomi

viimeinen n päivää

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

viimeinen n vuosineljännestä

last n weeks
Example
visitors last 10 weeks by day
Suomi

viimeinen n viikkoa

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

viimeinen n uotta

last quarter
Example
customers last quarter sale > 300
Suomi

viimeinen vuosineljännes

last week
Example
customers last week by store
Suomi

viimeinen viikko

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

viimeinen vuosi

month
Example
revenue by month last year
Suomi

kuukausi

month
Example
commission January
Suomi

kuukausi

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

kuukausi päivämäärään

month year
Example
commission by sales rep February 2014
Suomi

kuukausi vuosi

monthly
Example
commission > 10000 monthly
Suomi

kuukausittain

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

kuukausittain vuosivertailu

n days ago
Example
sales 2 days ago
Suomi

n päivää sitten

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

n päivää kullekin kuukausi

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

n päivää kullekin vuosineljännes

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

n päivää kullekin viikko

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

n päivää kullekin vuosi

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

n tuntia kullekin päivä

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

n kuukautta

n months ago
Example
sales 2 months ago by region
Suomi

n kuukautta sitten

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

n kuukautta kullekin vuosineljännes

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

n kuukautta kullekin vuosi

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

n vuosineljännestä sitten

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

n vuosineljännestä kullekin vuosi

n weeks ago
Example
sales 4 weeks ago by store
Suomi

n viikkoa sitten

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

n viikkoa kullekin kuukausi

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

n viikkoa kullekin vuosineljännes

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

n viikkoa kullekin vuosi

n years
Example
opportunities next 5 years by revenue
Suomi

n vuotta

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

n vuotta sitten

next day
Example
shipments next day by order
Suomi

seuraava päivä

next month
Example
appointments next month by day
Suomi

seuraava kuukausi

next n days
Example
shipments next 7 days
Suomi

seuraava n päivää

next n months
Example
openings next 6 months location
Suomi

seuraava n kuukautta

next n quarters
Example
opportunities next 2 quarters by campaign
Suomi

seuraava n vuosineljännestä

next n weeks
Example
shipments next 10 weeks by day
Suomi

seuraava n viikkoa

next quarter
Example
opportunities next quarter amount > 30000
Suomi

seuraava vuosineljännes

next week
Example
shipments next week by store
Suomi

seuraava viikko

next year
Example
opportunities next year by sales rep
Suomi

seuraava vuosi

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

vuosineljännes päivämäärään

quarterly
Example
sales quarterly for each product
Suomi

vuosineljännes

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

vuosineljännes vuosivertailu

this day
Example
shipments this day by order
Suomi

tämä päivä

this month
Example
appointments this month by day
Suomi

tämä kuukausi

this quarter
Example
opportunities this quarter amount > 30000
Suomi

tämä vuosineljännes

this week
Example
shipments this week by store
Suomi

tämä viikko

this year
Example
opportunities this year by sales rep
Suomi

tämä vuosi

today
Example
sales today by store
Suomi

tänään

week
Example
revenue by week last quarter
Suomi

viikko

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

viikko päivämäärään

weekly
Example
revenue weekly
Suomi

viikoittain

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

viikoittain vuosivertailu

year
Example
revenue by product 2014 product name contains snowboard
Suomi

vuosi

year to date
Example
sales by product year to date
Suomi

vuosi päivämäärään

yearly
Example
shipments by product yearly
Suomi

vuosittain

yesterday
Example
sales yesterday for pro-ski200 by store
Suomi

eilen

Time

detailed
Example
ship time detailed
Suomi

eritelty

last hour
Example
count unique visits last hour
Suomi

viimeinen tunti

last minute
Example
count homepage views last minute
Suomi

viimeinen minuutti

n hours
Example
count visitors [ last | next ] 12 hours
Suomi

n tuntia

n hours ago
Example
sum inventory by product by store 2 hours ago
Suomi

n tuntia sitten

n minutes
Example
count visitors [ last | next ] 30 minutes
Suomi

n minuuttia

n minutes ago
Example
sum inventory by product 10 minutes ago
Suomi

n minuuttia sitten

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)
Suomi

alkaa merkeillä

contains
Example
product name contains "alpine" description
  contains "snow shoe"
Suomi

sisältää

ends with
Example
product name ends with 'deluxe'
Suomi

pääty merkkeihin

similar to
Example
course name similar to 'hand'
Suomi

samankaltainen kuin

not begins with
Example
product name not begins with "tom's"
Suomi

ei ala merkeillä

not contains
Example
product color not contains 'tan'
  product color not contains 'red'
Suomi

ei sisällä

not ends with
Example
product name not ends with "trial"
Suomi

ei pääty merkkeihin

not similar to
Example
course name not similar to 'hand'
Suomi

erilainen kuin

Number

average
Example
average revenue by store
Suomi

keskiarvo

count
Example
count visitors by site
Suomi

määrä

max
Example
max sales by visitor by site
Suomi

maks.

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

min.

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

keskihajonta

sum
Example
sum revenue
Suomi

summa

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

yksilöllinen määrä

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

vaihtelu

Comparative

all
Example
revenue asia vs all
The all keyword can only be used as part of a versus phrase.
Suomi

kaikki

between... and...
Example
revenue between 0 and 1000
Suomi

välillä … ja

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

=

everything
Example
revenue asia vs everything
The everything keyword can only be used as part of a versus phrase.
Suomi

kaikki

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

>

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

>=

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

<

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

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

!=

vs, versus
Example
revenue east vs west
ThoughtSpot does not support the use of group_* formula measures with the vs keyword.
Suomi

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
Suomi

kauempana kuin alueen sisällä n mailia|km|metriä

near
Example
revenue store name county near san francisco
Suomi

lähellä

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

lähellä alueen sisällä n mailia|km|metriä

Period

day
Example
orders by day
Suomi

päivä (date)

day of month
Example
sales day of month by month
Suomi

kuukauden päivä (date)

day of quarter
Example
deals day of quarter by year
Suomi

vuosineljänneksen päivä (date)

day of week
Example
customers by week day of week
Suomi

viikonpäivä (date)

day of year
Example
ad clicks day of year by year
Suomi

vuoden päivä (date)

hour
Example
visitors by hour weekly
Suomi

tunti (datetime)

month of quarter
Example
purchases month of quarter by year
Suomi

vuosineljänneksen kuukausi (date)

quarter
Example
purchases by quarter
Suomi

vuosineljännes (date)

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

vuosineljännes (date)

week of month
Example
product shipments week of month yearly
Suomi

kuukauden viikko (date)

week of quarter
Example
revenue week of quarter
Suomi

vuosineljänneksen viikko (date)

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

viikon nro (date)