Español (Latinoamérica) Keyword reference

Use keywords to help define a search.

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 Español, you can only use Español keywords. You can’t also use English keywords, or any other language. ThoughtSpot doesn’t translate its branded terms, such as Liveboard or 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
Español

primeros 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
Español

primeros n por

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. 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
Español

primeros n …​ clasificado por

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
Español

últimos 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
Español

ordenar por

by <measure>

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

Examples
cost by revenue

product by quantity purchased
Español

por

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
Español

después de

before
Example
order date before 03/01/2014
Español

antes de

between ... and ...
Example
order date between 01/30/2012 and 01/30/2014
Español

entre … y …

daily
Example
shipments by region daily
Español

cada día

daily year-over-year
Example
growth of revenue by order date daily year-over-year
Español

cada día interanualmente

day
Example
count monday restaurant
Español

día

day of week
Example
revenue by day of week last 6 months
Español

día de la semana

day of week
Example
count shipments Monday
Español

día de la semana

growth of …​ by ...
Example
growth of sales by order date
Español

crecimiento de … mediante …

growth of …​ by …​ daily
Example
growth of sales by order date daily
Español

crecimiento de … mediante … cada día

growth of …​ by …​ monthly
Example
growth of sales by date shipped monthly sales > 24000
Español

crecimiento de … mediante … cada mes

growth of …​ by …​ quarterly
Example
growth of sales by date shipped quarterly
Español

crecimiento de … mediante … cada trimestre

growth of …​ by …​ weekly
Example
growth of sales by receipt date weekly for pro-ski2000
Español

crecimiento de … mediante … cada semana

growth of …​ by …​ yearly
Example
growth of sales by date closed yearly
Español

crecimiento de … mediante … cada año

hourly
Example
visitors by page name hourly
Español

cada hora

last day by
Example
customers last day by referrer
Español

último día mediante

last month by
Example
customers last month by day
Español

último mes mediante

last n days
Example
visitors last 7 days
Español

últimos n días

last n quarters
Example
visitors last 2 quarters by month by campaign
Español

últimos n trimestres

last n weeks
Example
visitors last 10 weeks by day
Español

últimas n semanas

last n years
Example
visitors last 5 years by revenue for sum revenue > 5000
Español

últimos n años

last quarter
Example
customers last quarter sale > 300
Español

último trimestre

last week
Example
customers last week by store
Español

última semana

last year
Example
top 10 customers last year by sale by store for region west
Español

último año

month
Example
revenue by month last year
Español

mes

month
Example
commission January
Español

mes

month to date
Example
sales by product month to date sales > 2400
Español

mes a la fecha

month year
Example
commission by sales rep February 2014
Español

mes año

monthly
Example
commission > 10000 monthly
Español

cada mes

monthly year-over-year
Example
growth of revenue
  by receipt date
  monthly year-over-year
Español

cada mes interanualmente

n days ago
Example
sales 2 days ago
Español

n días atrás

last n days for each month
Example
sales last 2 days for each month
Español

n días para cada mes

last n days for each quarter
Example
revenue last 15 days for each quarter
Español

n días para cada trimestre

last n days for each week
Example
total sold last 2 days for each week
Español

n días para cada semana

last n days for each year
Example
revenue last 300 days for each year
Español

n días para cada año

last n hours for each day
Example
sales last 2 hours for each day
Español

n días para cada año

n months
Example
visitors last 6 months for homepage visits > 30 by month
Español

n meses

n months ago
Example
sales 2 months ago by region
Español

n meses atrás

last n months for each quarter
Example
cost last 2 months for each quarter
Español

n meses para cada trimestre

last n months for each year
Example
last 8 months for each year
Español

n meses para cada año

n quarters ago
Example
sales 4 quarters ago by product name contains deluxe
Español

n trimestres atrás

last n quarters for each year
Example
last 2 quarters for each year
Español

n trimestres para cada año

n weeks ago
Example
sales 4 weeks ago by store
Español

n semanas atrás

last n weeks for each month
Example
sales last 3 weeks for each month
Español

n semanas para cada mes

last n weeks for each quarter
Example
last 2 weeks for each quarter
Español

n semanas para cada trimestre

last n weeks for each year
Example
last 3 weeks for each year
Español

n semanas para cada año

n years
Example
opportunities next 5 years by revenue
Español

n años

n years ago
Example
sales 5 years ago by store for region west
Español

n años atrás

next day
Example
shipments next day by order
Español

siguiente día

next month
Example
appointments next month by day
Español

siguiente mes

next n days
Example
shipments next 7 days
Español

siguiente n días

next n months
Example
openings next 6 months location
Español

siguiente n meses

next n quarters
Example
opportunities next 2 quarters by campaign
Español

siguiente n trimestres

next n weeks
Example
shipments next 10 weeks by day
Español

siguiente n semanas

next quarter
Example
opportunities next quarter amount > 30000
Español

siguiente trimestre

next week
Example
shipments next week by store
Español

siguiente semana

next year
Example
opportunities next year by sales rep
Español

siguiente año

quarter to date
Example
sales by product quarter to date
  for top 10 products by sales
Español

trimestre a la fecha

quarterly
Example
sales quarterly for each product
Español

cada trimestre

quarterly year-over-year
Example
growth of revenue by date shipped
quarterly year-over-year
Español

cada trimestre interanualmente

this day
Example
shipments this day by order
Español

este día

this month
Example
appointments this month by day
Español

este mes

this quarter
Example
opportunities this quarter amount > 30000
Español

este trimestre

this week
Example
shipments this week by store
Español

este semana

this year
Example
opportunities this year by sales rep
Español

este año

today
Example
sales today by store
Español

hoy

week
Example
revenue by week last quarter
Español

semana

week to date
Example
sales by order date week to date for pro-ski200
Español

semana a la fecha

weekly
Example
revenue weekly
Español

cada semana

weekly year-over-year
Example
growth of revenue by date shipped
  weekly year-over-year
Español

cada semana interanualmente

year
Example
revenue by product 2014 product name contains snowboard
Español

año

year to date
Example
sales by product year to date
Español

año a la fecha

yearly
Example
shipments by product yearly
Español

cada año

yesterday
Example
sales yesterday for pro-ski200 by store
Español

ayer

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
Español

detallado

last hour
Example
count unique visits last hour
Español

último hora

last minute
Example
count homepage views last minute
Español

último minuto

n hours
Example
count visitors [ last | next ] 12 hours
Español

n horas

n hours ago
Example
sum inventory by product by store 2 hours ago
Español

n horas atrás

n minutes
Example
count visitors [ last | next ] 30 minutes
Español

n minutos

n minutes ago
Example
sum inventory by product 10 minutes ago
Español

n minutos atrás

Text

  • begins with

  • contains

  • ends with

  • similar to

  • not begins with

  • not contains

  • not ends with

  • not similar to

    Español
    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)
    Español

    comienza con

contains
Example
product name contains "alpine" description
  contains "snow shoe"
Español

contiene

ends with
Example
product name ends with 'deluxe'
Español

termina con

similar to
Example
course name similar to 'hand'
Español

similar a

not begins with
Example
product name not begins with "tom's"
Español

no comienza con

not contains
Example
product color not contains 'tan'
  product color not contains 'red'
Español

no termina con

not ends with
Example
product name not ends with "trial"
Español

no termina con

not similar to
Example
course name not similar to 'hand'
Español

diferente de

Number

average
Example
average revenue by store
Español

promedio

count
Example
count visitors by site
Español

recuento

max
Example
max sales by visitor by site
Español

máx

min
Example
min revenue by store by campaign for cost > 5000
Español

mín

standard deviation
Example
standard deviation revenue by product by month for date after
10/31/2010
Español

desviación estándar

sum
Example
sum revenue
Español

suma

unique count
Example
unique count visitor by product page last week
Español

recuento único

variance
Example
variance sale amount by visitor by product for last year
Español

varianza

Comparative

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

todo/a

between... and...
Example
revenue between 0 and 1000
Español

entre … y

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

=

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

todo/a

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

>

>= (greater than or equal)
Example
count calls by employee lastname >= m
Español

>=

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

<

<= (less than or equal)
Example
count shipments by city latitude <= 0
Español

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

!=

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

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}. 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

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
Español

más lejos que n millas|km|metros de

near
Example
revenue store name county near san francisco
Español

cerca

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

cerca …​ en n millas|km|metros

Period

day
Example
orders by day
Español

día (date)

day of month
Example
sales day of month by month
Español

día del mes (date)

day of quarter
Example
deals day of quarter by year
Español

día del trimestre (date)

day of week
Example
customers by week day of week
Español

día de la semana (date)

day of year
Example
ad clicks day of year by year
Español

día del año (date)

hour
Example
visitors by hour weekly
Español

hora (datetime)

month of quarter
Example
purchases month of quarter by year
Español

mes del trimestre (date)

quarter
Example
purchases by quarter
Español

trimestre (date)

quarter of year
Example
opportunities quarter of year last 4 years yearly
Español

trimestre del año (date)

week of month
Example
product shipments week of month yearly
Español

semana del mes (date)

week of quarter
Example
revenue week of quarter
Español

semana del trimestre (date)

week of year
Example
new products week of year last 3 years yearly
Español

semana del año (date)