Use keywords to help define a search.

You can use keywords when asking a question to help define your search. This reference lists the various keywords.

< Back to English Keywords page

General

English Keywords Português Keywords Examples
top superior
  • top sales rep by count sales for average revenue > 10000
  • sales rep average revenue for each region top
bottom inferior
  • bottom revenue average
  • bottom revenue by state
  • customer by revenue for each sales rep bottom
n n top 10 sales rep revenue
n n bottom 25 customer by revenue for each sales rep
sort by classificar por
  • revenue by state sort by average revenue
  • revenue by customer sort by region

Date

English Keywords Português Keywords Examples
after após order date after 10/31/2014
before antes order date before 03/01/2014
between … and ... entre … e … order date between 01/30/2012 and 01/30/2014
daily year-over-year diariamente ano à ano growth of revenue by order date daily year-over-year
daily diariamente shipments by region daily
day dia count monday restaurant
day of week dia da semana revenue by day of week last 6 months
day of week dia da semana count shipments Monday
n days for each month n dias para cada mês sales last 2 days for each month
n days for each quarter n dias para cada trimestre revenue last 15 days for each quarter
n days for each week n dias para cada semana total sold last 2 days for each week
n days for each year n dias para cada anoe revenue last 300 days for each year
growth of … by … daily crescimento de … por … diariamente growth of sales by order date daily
growth of … by … monthly crescimento de … por … mensalmente growth of sales by date shipped monthly sales > 24000
growth of … by … quarterly crescimento de … por … trimestralmente growth of sales by date shipped quarterly
growth of … by … weekly crescimento de … por … semanalmente growth of sales by receipt date weekly for pro-ski2000
growth of … by … yearly crescimento de … por … anualmente growth of sales by date closed yearly
growth of … by ... crescimento de … por … growth of sales by order date
n hours for each day n horas para cada dia sales last 2 hours for each day
last day by último dia por customers last day by referrer
hourly de hora em hora visitors by page name hourly
last month by último mês por customers last month by day
last n days último n dias visitors last 7 days
last n quarters último n trimestres visitors last 2 quarters by month by campaign
last n weeks último n semanas visitors last 10 weeks by day
last quarter último trimestre customers last quarter sale >300
last week último semana customers last week by store
last year último ano top 10 customers last year by sale by store for region west
last n years último n anos visitors last 5 years by revenue for sum revenue >5000
month to date mês até a data sales by product month to date sales > 2400
month year mês ano commission by sales rep February 2014
month mês commission January
month mês revenue by month last year
monthly year-over-year mensalmente ano à ano growth of revenue by receipt date monthly year-over-year
monthly mensalmente commission > 10000 monthly
n months for each quarter n meses para cada trimestrere cost last 2 months for each quarter
n months for each year n meses para cada ano last 8 months for each year
n days ago n dias atrás sales 2 days ago
n months ago n meses atrás sales 2 months ago by region
n months n meses visitors last 6 months for homepage visits > 30 by month
n quarters ago n trimestres atrás sales 4 quarters ago by product name contains "deluxe"
n weeks ago n semanas atrás sales 4 weeks ago by store
n years ago n ano atrás sales 5 years ago by store for region west
n years n anos opportunities next 5 years by revenue
next day próximo dia shipments next day by order
next month próximo mês appointments next month by day
next n days próximo n dias shipments next 7 days
next n months próximo n meses openings next 6 months location
next n quarters próximo n trimestres opportunities next 2 quarters by campaign
next n weeks próximo n semanas shipments next 10 weeks by day
next quarter próximo trimestre opportunities next quarter amount > 30000
next week próximo semana shipments next week by store
next year próximo ano opportunities next year by sales rep
quarter to date trimestre até a data sales by product quarter to date for top 10 products by sales
quarterly year-over-year trimestralmente ano à ano growth of revenue by date shipped quarterly year-over-year
quarterly trimestralmente sales quarterly for each product
n quarters for each year n trimestres para cada ano last 2 quarters for each year
today hoje sales today by store
week to date semana até a data sales by order date week to date for pro-ski200
week semana revenue by week last quarter
weekly year-over-year semanalmente ano à ano growth of revenue by date shipped weekly year-over-year
weekly semanalmente revenue weekly
n weeks for each month n semanas para cada mês sales last 3 weeks for each month
n weeks for each quarter n semanas para cada trimestre last 2 weeks for each quarter
n weeks for each year n semanas para cada ano last 3 weeks for each year
year to date ano até a data sales by product year to date
year ano revenue by product 2014 product name contains "snowboard"
yearly anualmente shipments by product yearly
yesterday ontem sales yesterday for pro-ski200 by store

Time

English Keywords Português Keywords Examples
detailed detalhado ship time detailed
last minute último minuto count homepage views last minute
last hour último hora count unique visits last hour
n minutes n minutos count visitors last 30 minutes
n hours n horas count visitors last 12 hours
n minutes ago n minutos atrás sum inventory by product 10 minutes ago
n hours ago n horas atrás sum inventory by product by store 2 hours ago

Text

English Keywords Português Keywords Examples
begins with começa com product name begins with 'pro'
contains contém product name contains "alpine" description contains "snow shoe"
ends with termina com product name ends with 'deluxe'
not begins with não começa com product name not begins with "tom's"
not contains não contém product color not contains 'tan' product color not contains 'red'
not ends with não termina com product name not ends with "trial"
similar to semelhante a course name similar to 'hand'
not similar to não semelhante a course name not similar to 'hand'

Number

English Keywords Português Keywords Examples
sum soma sum revenue
average média average revenue by store
count contagem count visitors by site
max máx max sales by visitor by site
min mín min revenue by store by campaign for cost > 5000
standard deviation desvio padrão standard deviation revenue by product by month for date after
unique count contagem única unique count visitor by product page last week
variance variância variance sale amount by visitor by product for last year

Comparative

English Keywords Português Keywords Examples
all todos all
between... and entre … e revenue between 0 and 1000
vs, versus vs, versus revenue east vs west
> > 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

Location

English Keywords Português Keywords Examples
near perto de revenue store name county near san francisco
near... within n miles|km|meters perto de … dentro de n milhas|km|metros revenue store name county near alameda within 50 miles
farther than n miles|km|meters from mais distante de n milhas|km|metros de average hours worked branch farther than 80 km from scarborough

Period

English Keywords Português Keywords Examples
quarter (date) trimestre (date) quarter (purchase date)
quarter of year (date) trimestre do ano (date) quarter of year (purchase date)
month of quarter (date) mês do trimestre (date) month of quarter (purchase date)
week of year (date) semana do ano (date) week of year (ship date)
week of quarter (date) semaine du trimestre (date) week of quarter (ship date)
week of month (date) semana do mês (date) week of month (ship date)
day of year (date) dia do ano (date) day of year (ship date)
day of quarter (date) dia do trimestre (date) day of quarter (ship date)
day (date) dia (date) day (ship date)
day of month (date) dia do mês (date) day of month (order date)
day of week (date) dia da semana (date) day of week (order date)
hour (datetime) hora (datetime) hour (timestamp)
https://cloud-docs.thoughtspot.com/reference/keywords-pt-br
cloud-docs.thoughtspot.com
crawl=CC-MAIN-2021-39
144821
application/http; msgtype=response
sha1:JWIHY2MRAC7IVJKUVQYLXRZX5ETBR7KV
<urn:uuid:83cfa23c-7d67-45a2-a0c7-db276eead563>
2021-09-23T21:57:03Z
68.183.23.220
text/html
sha1:JL743B4TLCVQKP7H5ITTLRH7L6KI4TDK
<urn:uuid:a88a50d6-edb2-4e06-a7c0-cf3366fd19c7>
https://cloud-docs.thoughtspot.com/reference/keywords-pt-br
response
<urn:uuid:bd511a7f-e982-488d-a526-36cc88d4035a>
isPartOf: CC-MAIN-2021-39
publisher: Common Crawl
description: Wide crawl of the web for September 2021
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-204
software: Apache Nutch 1.18 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.2-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: https://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/