Skip to main content
ThoughtSpot

Keyword Reference

Use the search bar to ask a question using column names, values and keywords. 

Basic Keywords

top n…ranked by…

top 10 sales rep ranked by revenue

top 25 sales rep ranked by average revenue for each region

top 5 sales rep ranked by count sales for average revenue > 10000

bottom n…ranked by… 

bottom 10 revenue ranked by average revenue by state

bottom 25 customer ranked by revenue for each sales rep

sort by

revenue by state sort by average revenue 

revenue by customer sort by region

Date Keywords

after order date after 10/31/2014
before order date before 03/01/2014
between … and … order date between 01/01/2012 and 01/01/2013
day of week  revenue by day of week last 6 months
week

revenue by week last quarter

month revenue by month last year
daily shipments by region daily
weekly revenue weekly
monthly commission > 10000 monthly
quarterly sales quarterly for each product
yearly shipments by product yearly
day of week count shipments Monday
month commission January
month year commission by sales rep February 2014
year revenue by product 2013 product name contains snowboard
yesterday sales yesterday for pro-ski200 by store
week to date sales by order date week to date for pro-ski200
month to date sales by product month to date sales > 2400
quarter to date sales by product quarter to date for top 10 products by sales
year to date sales by product year to date

last

      day

      week

      month

      quarter

      year

 

customers last day by referrer

customers last week by store

customers last month by day

customers last quarter sale > 300

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

last

      n days

      n weeks

      n months

      n quarters

      n years

 

visitors last 7 days

visitors last 10 weeks by day

visitors last 6 months for homepage visits > 30 by month

visitors last 2 quarters by month by campaign

visitors last 5 years by revenue for sum revenue > 5000

growth of ... by ...

      daily

      monthly

      weekly

      quarterly

      yearly

growth of sales by order date

growth of sales by order date daily 

growth of sales by date shipped monthly sales > 24000

growth of sales by receipt date weekly for pro-ski2000

growth of sales by date shipped quarterly 

growth of sales by date closed yearly

daily year-over-year growth of revenue by order date daily year-over-year
weekly year-over-year growth of revenue by date shipped weekly year-over-year
monthly year-over-year growth of revenue by receipt date monthly year-over-year
quarterly year-over-year growth of revenue by date shipped quarterly year-over-year
yearly year-over-year growth of revenue by date closed yearly year-over-year
n days ago sales 2 days ago
n weeks ago sales 4 weeks ago by store
n months ago sales 2 months ago by region
n quarters ago sales 4 quarters ago by product name contains deluxe
n years ago sales 5 years ago by store for region west

Time Keywords

 

detailed

ship time detailed 

last

    minute  

    hour  

 

count homepage views last minute

count unique visits last hour

last

    n minutes        

    n hours    

 

count visitors last 30 minutes

count visitors last 12 hours

hourly        

visitors by page name hourly

n minutes ago

n hours ago

sum inventory by product 10 minutes ago

sum inventory by product by store 2 hours ago

Text Keywords

begins with

product name begins with pro

contains

product description contains ski contains 'snow shoe'

ends with

product name ends with deluxe

not begins with

product name not begins with basic

not contains    

product color not contains tan product color not contains red

not ends with

product name not ends with trial

Number Keywords

sum

sum revenue

average

average revenue by store

count

count visitors by site 

max

max sales by visitor by site

min

min revenue by store by campaign for cost > 5000

standard deviation

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

unique count

unique count visitor by product page last week

variance

variance sale amount by visitor by product for last year

Filter Keywords

between…and

revenue between 0 and 1000

>

sum sale amount by visitor by product for last year sale amount > 2000

<

unique count visitor by product by store for sale amount < 20

>=

count calls by employee lastname >= m

<=

count shipments by city latitude <= 0

=

unique count visitor by store purchased products = 3 for last 5 days

!=

sum sale amount region != canada region != mexico

  • Was this article helpful?