中文 (繁體) keyword reference

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 中文 (繁體), you can only use 中文 (繁體) keywords. You can’t also use English keywords, or any other language. ThoughtSpot doesn’t translate its branded terms, such as Liveboard, SpotIQ, and so on.

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
中文 (繁體)

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
中文 (繁體)

前 n 根据

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
中文 (繁體)

n …​ 按…​ 排名

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
中文 (繁體)

n

sort by

Sorts the result set by an attribute or measure.

Example
revenue by customer sort by region sort by state
中文 (繁體)

按…​ 排序

sort by …​ ascending

Sorts the result set by a measure, in order from the smallest to the largest.

Example
revenue by state sort by average revenue ascending
中文 (繁體)

按…​ 排序上升

sort by …​ descending

Sorts the result set by a measure, in order from the largest to the smallest.

Examples
revenue by state sort by average revenue descending
中文 (繁體)

按…​ 排序下降

by <measure>

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

Examples
cost by revenue

product by quantity purchased
中文 (繁體)

根据

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
中文 (繁體)

在……之后

April
Example
order date April
中文 (繁體)

四月

August
Example
order date August
中文 (繁體)

八月

before
Example
order date before 03/01/2014
中文 (繁體)

在……之前

between ... and ...
Example
order date between 01/30/2012 and 01/30/2014
中文 (繁體)

在……之间 … 和

calendar
Example
sales transaction date calendar

Specifies use of the standard Gregorian calendar, rather than a custom calendar that may be specified for the date attribute used.

中文 (繁體)

no translation

daily
Example
shipments by region daily
中文 (繁體)

每日

daily year-over-year
Example
growth of revenue by order date daily year-over-year
中文 (繁體)

每日 年度同比

day
Example
count monday restaurant
中文 (繁體)

day of month
Example
sales day of month by month
中文 (繁體)

某月中的某天

day of quarter
Example
deals day of quarter by year
中文 (繁體)

某季度中的某天

day of week
Example
revenue by day of week last 6 months
中文 (繁體)

每週的某一日

day of week
Example
count shipments Monday
中文 (繁體)

每週的某一日

day of year
Example
ad clicks day of year by year
中文 (繁體)

某年中的某天

December
Example
order date December
中文 (繁體)

十二月

February
Example
order date February
中文 (繁體)

二月

Friday
Example
order date Friday
中文 (繁體)

週五

growth of …​ by ...
Example
growth of sales by order date
中文 (繁體)

的增長 … 根据

growth of …​ by …​ daily
Example
growth of sales by order date daily
中文 (繁體)

的增長 … 根据 每日

growth of …​ by …​ monthly
Example
growth of sales by date shipped monthly sales > 24000
中文 (繁體)

的增長 … 根据 每月

growth of …​ by …​ quarterly
Example
growth of sales by date shipped quarterly
中文 (繁體)

的增長 … 根据 每季

growth of …​ by …​ weekly
Example
growth of sales by receipt date weekly for pro-ski2000
中文 (繁體)

的增長 … 根据 每週

growth of …​ by …​ yearly
Example
growth of sales by date closed yearly
中文 (繁體)

的增長 … 根据 每年

January
Example
order date January
中文 (繁體)

一月

July
Example
order date July
中文 (繁體)

七月

June
Example
order date June
中文 (繁體)

六月

last day by
Example
customers last day by referrer
中文 (繁體)

上一個 天 根据

last month
Example
customers last month by store
中文 (繁體)

上一個 月

last month by
Example
customers last month by day
中文 (繁體)

上一個 月 根据

last n days
Example
visitors last 7 days
中文 (繁體)

上一個 n

last n days for each month
Example
sales last 2 days for each month
中文 (繁體)

上一個 n 天 對於每個 月

last n days for each quarter
Example
revenue last 15 days for each quarter
中文 (繁體)

上一個 n 天 對於每個 季度

last n days for each week
Example
total sold last 2 days for each week
中文 (繁體)

上一個 n 天 對於每個 星期

last n days for each year
Example
revenue last 300 days for each year
中文 (繁體)

上一個 n 天 對於每個 年

last n hours for each day
Example
sales last 2 hours for each day
中文 (繁體)

上一個 n 小時 對於每個 天

last n months
Example
visitors last 10 months by day
中文 (繁體)

上一個 n

last n months for each quarter
Example
cost last 2 months for each quarter
中文 (繁體)

上一個 n 月 對於每個 季度

last n months for each year
Example
last 8 months for each year
中文 (繁體)

上一個 n 月 對於每個 年

last n quarters
Example
visitors last 2 quarters by month by campaign
中文 (繁體)

上一個 n 季度

last n quarters for each year
Example
last 2 quarters for each year
中文 (繁體)

上一個 n 季度 對於每個 年

last n weeks
Example
visitors last 10 weeks by day
中文 (繁體)

上一個 n 星期

last n weeks for each month
Example
sales last 3 weeks for each month
中文 (繁體)

上一個 n 星期 對於每個 月

last n weeks for each quarter
Example
last 2 weeks for each quarter
中文 (繁體)

上一個 n 星期 對於每個 季度

last n weeks for each year
Example
last 3 weeks for each year
中文 (繁體)

上一個 n 星期 對於每個 年

last n years
Example
visitors last 5 years by revenue for sum revenue > 5000
中文 (繁體)

上一個 n

last quarter
Example
customers last quarter sale > 300
中文 (繁體)

上一個 季度

last week
Example
customers last week by store
中文 (繁體)

上一個 星期

last year
Example
top 10 customers last year by sale by store for region west
中文 (繁體)

上一個 年

March
Example
order date March
中文 (繁體)

三月

May
Example
order date May
中文 (繁體)

五月

Monday
Example
order date Monday
中文 (繁體)

週一

month
Example
revenue by month last year
中文 (繁體)

month
Example
commission January
中文 (繁體)

month to date
Example
sales by product month to date sales > 2400
中文 (繁體)

月 迄今

month year
Example
commission by sales rep February 2014
中文 (繁體)

月 年

monthly
Example
commission > 10000 monthly
中文 (繁體)

每月

monthly year-over-year
Example
growth of revenue
  by receipt date
  monthly year-over-year
中文 (繁體)

每月 年度同比

n days ago
Example
sales 2 days ago
中文 (繁體)

n 天 以前

n months
Example
visitors last 6 months for homepage visits > 30 by month
中文 (繁體)

n

n months ago
Example
sales 2 months ago by region
中文 (繁體)

n 月 以前

n quarters ago
Example
sales 4 quarters ago by product name contains deluxe
中文 (繁體)

n 季度 以前

n weeks ago
Example
sales 4 weeks ago by store
中文 (繁體)

n 星期 以前

n years
Example
opportunities next 5 years by revenue
中文 (繁體)

n

n years ago
Example
sales 5 years ago by store for region west
中文 (繁體)

n 年 以前

next day
Example
shipments next day by order
中文 (繁體)

下一個 天

next month
Example
appointments next month by day
中文 (繁體)

下一個 月

next n days
Example
shipments next 7 days
中文 (繁體)

下一個 n

next n days for each month
Example
sales next 2 days for each month
中文 (繁體)

下一個 n 天 對於每個 月

next n days for each quarter
Example
revenue next 15 days for each quarter
中文 (繁體)

下一個 n 天 對於每個 季度

next n days for each week
Example
total sold next 2 days for each week
中文 (繁體)

下一個 n 天 對於每個 星期

next n days for each year
Example
revenue next 300 days for each year
中文 (繁體)

下一個 n 天 對於每個 年

next n months
Example
openings next 6 months location
中文 (繁體)

下一個 n

next n months for each quarter
Example
cost next 2 months for each quarter
中文 (繁體)

下一個 n 月 對於每個 季度

next n months for each year
Example
next 8 months for each year
中文 (繁體)

下一個 n 月 對於每個 年

next n quarters
Example
opportunities next 2 quarters by campaign
中文 (繁體)

下一個 n 季度

next n quarters for each year
Example
sales next 2 quarters for each year
中文 (繁體)

下一個 n 季度 對於每個 年

next n weeks
Example
shipments next 10 weeks by day
中文 (繁體)

下一個 n 星期

next n weeks for each month
Example
sales next 3 weeks for each month
中文 (繁體)

下一個 n 星期 對於每個 月

next n weeks for each quarter
Example
revenue next 2 weeks for each quarter
中文 (繁體)

下一個 n 星期 對於每個 季度

next n weeks for each year
Example
sales next 3 weeks for each year
中文 (繁體)

下一個 n 星期 對於每個 年

next quarter
Example
opportunities next quarter amount > 30000
中文 (繁體)

下一個 季度

next week
Example
shipments next week by store
中文 (繁體)

下一個 星期

next year
Example
opportunities next year by sales rep
中文 (繁體)

下一個 年

November
Example
order date November
中文 (繁體)

十一月

October
Example
order date October
中文 (繁體)

十月

q1

The first quarter of the fiscal year.

Example
sales q1
中文 (繁體)

一季度

q2

The second quarter of the fiscal year.

Example
sales q2
中文 (繁體)

二季度

q3

The third quarter of the fiscal year.

Example
sales q3
中文 (繁體)

三季度

q4

The fourth quarter of the fiscal year.

Example
sales q4
中文 (繁體)

四季度

quarter to date
Example
sales by product quarter to date
  for top 10 products by sales
中文 (繁體)

季度 迄今

quarterly
Example
sales quarterly for each product
中文 (繁體)

每季

quarterly year-over-year
Example
growth of revenue by date shipped
quarterly year-over-year
中文 (繁體)

每季 年度同比

Saturday
Example
order date Saturday
中文 (繁體)

週六

September
Example
order date September
中文 (繁體)

九月

Sunday
Example
order date Sunday
中文 (繁體)

週日

this day
Example
shipments this day by order
中文 (繁體)

這個 天

this month
Example
appointments this month by day
中文 (繁體)

這個 月

this quarter
Example
opportunities this quarter amount > 30000
中文 (繁體)

這個 季度

this week
Example
shipments this week by store
中文 (繁體)

這個 星期

this year
Example
opportunities this year by sales rep
中文 (繁體)

這個 年

Thursday
Example
order date Thursday
中文 (繁體)

週四

today
Example
sales today by store
中文 (繁體)

今天

Tuesday
Example
order date Tuesday
中文 (繁體)

週二

Wednesday
Example
order date Wednesday
中文 (繁體)

週三

week
Example
revenue by week last quarter
中文 (繁體)

星期

week to date
Example
sales by order date week to date for pro-ski200
中文 (繁體)

星期 迄今

weekly
Example
revenue weekly
中文 (繁體)

每週

weekly year-over-year
Example
growth of revenue by date shipped
  weekly year-over-year
中文 (繁體)

每週 年度同比

year
Example
revenue by product 2014 product name contains snowboard
中文 (繁體)

year to date
Example
sales by product year to date
中文 (繁體)

年 迄今

yearly
Example
shipments by product yearly
中文 (繁體)

每年

yesterday
Example
sales yesterday for pro-ski200 by store
中文 (繁體)

昨天

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
中文 (繁體)

詳細的

hourly
Example
visitors by page name hourly
中文 (繁體)

每小時

last hour
Example
count unique visits last hour
中文 (繁體)

上一個 小時

last minute
Example
count homepage views last minute
中文 (繁體)

上一個 分鐘

n hours
Example
count visitors [ last | next ] 12 hours
中文 (繁體)

n 小時

n hours ago
Example
sum inventory by product by store 2 hours ago
中文 (繁體)

n 小時 以前

n minutes
Example
count visitors [ last | next ] 30 minutes
中文 (繁體)

n 分鐘

n minutes ago
Example
sum inventory by product 10 minutes ago
中文 (繁體)

n 分鐘 以前

next hour
Example
count projected visitors next hour
中文 (繁體)

下一個 小時

next minute
Example
count projected visitors next minute
中文 (繁體)

下一個 分鐘

this hour
Example
count visitors this hour
中文 (繁體)

這個 小時

this minute
Example
count visitors this minute
中文 (繁體)

這個 分鐘

Text

begins with
Examples
product name begins with 'pro'

The preceding phrase returns all products that start with 'pro'. For example, this phrase might return pro sport set, but it wouldn’t return beginner sport set.

product name begins with 'pro' or 'sport'
OR
product name begins with 'pro' product name begins with 'sport'

The preceding phrases both return all products that start with 'pro' or 'sport'. For example, either of these phrases might return pro sport set or sport set, but they wouldn’t return beginner sport set.

product name begins with 'pro'
  product color begins with 'bl'

The preceding phrase returns all products that start with 'pro', if the product color also starts with 'bl'. For example, this phrase might return a blue pro sport set.

begins with phrases can’t be combined with and.

中文 (繁體)

以…​…​ 開始

contains
Example
country name contains 'a' or 'b'
OR
country name contains 'a' country name contains 'b'

The preceding phrases both return country names that contain the letter a and country names that contain the letter b. For example, either of these phrases might return North America.

If your query includes two or more contains phrases that modify the same column, ThoughtSpot combines the phrases using or logic. Prior to ThoughtSpot version 9.5.0.sw, ThoughtSpot combined these phrases using and logic. If you have existing Answers or visualizations using this and logic, ThoughtSpot will automatically update your queries after you upgrade to 9.5.0.sw, to ensure they return the same information.
country name contains 'a' and 'b'

The preceding phrase returns only country names that contain both the letter a and the letter b. For example, this phrase might return Azerbaijan, but it wouldn’t return North America.

中文 (繁體)

包含

ends with
Example
product name ends with 'deluxe'

The preceding phrase returns product names that end with 'deluxe'. For example, this phrase might return bath towels deluxe, but it wouldn’t return deluxe bath towels.

product name ends with 'deluxe' or 'luxury'
OR
product name ends with 'deluxe' product name ends with 'luxury'

The preceding phrases both return product names that end with 'deluxe' or 'luxury'. For example, either of these phrases might return bath towels deluxe or bath towels luxury, but they wouldn’t return deluxe bath towels.

ends with phrases can’t be combined with and.

中文 (繁體)

以……结束

similar to
Example
product name similar to 'jacket'

The preceding phrase returns all products that contain text similar to 'jacket'. For example, this phrase might return jean jacket men’s, but it wouldn’t return t-shirt.

product name similar to 'jacket' or 't-shirt'
OR
product name similar to 'jacket' product name similar to 't-shirt'

The preceding phrases both return all products that contain text similar to 'jacket' or 't-shirt'. For example, either of these phrases might return jean jacket men’s or white t-shirt, but they wouldn’t return green hat.

similar to phrases can’t be combined with and.

中文 (繁體)

類似於

not begins with
Example
product name not begins with 'pro'

The preceding phrase returns all products that do not start with 'pro'. For example, this phrase might return beginner sport set, but it wouldn’t return pro sport set.

product name not begins with 'pro' or 'sport'
OR
product name not begins with 'pro' product name not begins with 'sport'

The preceding phrases both return all products that do not start with 'pro' and do not start with 'sport'. For example, either of these phrases might return beginner sport set, but they wouldn’t return pro sport set or sport set.

中文 (繁體)

不以…​…​開始

not contains
Example
country name not contains 'a' country name not contains 'b'
OR
country name not contains 'a' or 'b'

The preceding phrases both return country names that do not contain the letter a or the letter b. For example, either of these phrases might return Yemen, but they wouldn’t return North America or Azerbaijan.

country name not contains 'a' and 'b'

The preceding phrase returns country names that contain neither the letter a nor the letter b. For example, this phrase would return North America, but not Azerbaijan.

中文 (繁體)

不包含

not ends with
Example
product name not ends with 'luxury'

The preceding phrase returns all products that do not end with 'luxury'. For example, this phrase might return bath towels basic, but it wouldn’t return bath towels luxury.

product name not ends with 'luxury' or 'deluxe'
OR
product name not ends with 'luxury' product name not ends with 'deluxe'

The preceding phrases both return all products that do not end with 'luxury' and do not end with 'deluxe'. For example, either of these phrases might return bath towels basic, but they wouldn’t return bath towels luxury or bath towels deluxe.

中文 (繁體)

不以…​…​ 結束

not similar to
Example
product name not similar to 'jacket'

The preceding phrase returns all products that do not contain text that is similar to 'jacket'. For example, this phrase might return t-shirt, but it wouldn’t return jean jacket men’s.

product name not similar to 'jacket' or 't-shirt'
OR
product name not similar to 'jacket' product name not similar to 't-shirt'

The preceding phrases both return all products that do not contain text similar to 'jacket' and do not contain text similar to 't-shirt'. For example, either of these phrases might return green hat, but they wouldn’t return jean jacket men’s or t-shirt.

中文 (繁體)

不類似於

Number

average
Example
average revenue by store
中文 (繁體)

平均值

count
Example
count visitors by site
中文 (繁體)

計數

max
Example
max sales by visitor by site
中文 (繁體)

最大

min
Example
min revenue by store by campaign for cost > 5000
中文 (繁體)

最小

standard deviation
Example
standard deviation revenue by product by month for date after
10/31/2010
中文 (繁體)

標準偏差

sum
Example
sum revenue
中文 (繁體)

總計

unique count
Example
unique count visitor by product page last week
中文 (繁體)

去重計數

variance
Example
variance sale amount by visitor by product for last year
中文 (繁體)

方差

Comparative

all
Example
revenue asia vs all
The all keyword can only be used as part of a versus phrase.
中文 (繁體)

所有

between... and...
Example
revenue between 0 and 1000
中文 (繁體)

在……之间 …​ 和

= (equal)
Example
unique count visitor by store purchased products = 3 for last 5
days
中文 (繁體)

=

everything
Example
revenue asia vs everything
The everything keyword can only be used as part of a versus phrase.
中文 (繁體)

一切

> (greater than)
Example
sum sale amount by visitor by product for last year sale amount > 2000
中文 (繁體)

>

>= (greater than or equal)
Example
count calls by employee lastname >= m
中文 (繁體)

>=

< (less than)
Example
unique count visitor by product by store for sale amount < 20
中文 (繁體)

<

<= (less than or equal)
Example
count shipments by city latitude <= 0
中文 (繁體)

!= (not equal)
Example
sum sale amount region != canada date != last 5 days
中文 (繁體)

!=

vs, versus
Example
revenue east vs west
ThoughtSpot supports use of multiple contains, begins_with, and ends_with phrases in vs queries. For example, you can now have a versus query such as [state name begins_with 'a'] [state name begins_with 'c'] [vs] [state name begins_with 'd']. For multiple contains, begins_with`, ends_with phrases on the same side of the versus query, ThoughtSpot will combine the phrases using OR.
ThoughtSpot does not support the use of group_* formula measures with the vs keyword. ThoughtSpot doesn’t support the use of the vs keyword within an in or not in subquery.
中文 (繁體)

vs
比較

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

farther than n miles|km|meters from …​
Example
average hours worked branch farther than 80 km from scarborough
中文 (繁體)

比……更远 n [英里 | 千米 | 米 ] 从……起

near
Example
revenue store name county near san francisco
中文 (繁體)

接近

near …​ within n miles|km|meters
Example
revenue store name county near alameda within 50 miles
中文 (繁體)

接近 …​ 在……之内 n [英里 | 千米 | 米 ]

Period

day
Example
orders by day
中文 (繁體)

day of month
Example
sales day of month by month
中文 (繁體)

某月中的某天

day of quarter
Example
deals day of quarter by year
中文 (繁體)

某季度中的某天

day of week
Example
customers by week day of week
中文 (繁體)

每週的某一日

day of year
Example
ad clicks day of year by year
中文 (繁體)

某年中的某天

hour
Example
visitors by hour weekly
中文 (繁體)

小時

hour of day
Example
visitors by page name hour of day
中文 (繁體)

某天中的某個小時

month of quarter
Example
purchases month of quarter by year
中文 (繁體)

某季度的某月

month of year
Example
purchases month of year by year
中文 (繁體)

某年中某月

quarter
Example
purchases by quarter
中文 (繁體)

季度

quarter of year
Example
opportunities quarter of year last 4 years yearly
中文 (繁體)

某年的某季度

week of month
Example
product shipments week of month yearly
ThoughtSpot uses ISO week format for the week of [month | quarter | year] keywords, which means that the last few days of a quarter may sometimes show as the first few days of the next quarter, based on the ISO week date system.
中文 (繁體)

某月中某星期

week of quarter
Example
revenue week of quarter
ThoughtSpot uses ISO week format for the week of [month | quarter | year] keywords, which means that the last few days of a quarter may sometimes show as the first few days of the next quarter, based on the ISO week date system.
中文 (繁體)

某季度中某星期

week of year
Example
new products week of year last 3 years yearly
ThoughtSpot uses ISO week format for the week of [month | quarter | year] keywords, which means that the last few days of a quarter may sometimes show as the first few days of the next quarter, based on the ISO week date system.
中文 (繁體)

某年中某星期

In / Not in

in

Query in query search (intersection of two sets). Must match last attribute before keyword with first attribute inside subsearch. Doesn’t support use of the vs keyword.

Syntax
attribute in (attribute subsearch)
Examples
store name in (top 10 store name by sales footwear)

product name 2014 product name in (product name 2013) sales
中文 (繁體)

在…​ …​裡

not in

Relative complement of two sets. Must match last attribute before keyword with first attribute inside subsearch. Doesn’t support use of the vs keyword.

Syntax
attribute not in (attribute subsearch)
Example
product name 2014 product name not in (product name 2013) sales

Find sales for all products ordered in 2014 that were not ordered in 2013

中文 (繁體)

不在…​ …​裡


Was this page helpful?