中文 (繁體) Keyword reference
Use keywords when asking a question to help define your search. This reference lists the various keywords.
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.
If you enter multiple measures in your search, ThoughtSpot sorts by the first measure. For example, if you search for
top 3 sales by product quantity purchased
, ThoughtSpot sorts by sales. If you change the search to sort by a different column, such astop 3 sales by product sort by quantity purchased
, ThoughtSpot sorts by quantity purchased but preserves the top three ranked by sales.If you search for "top n by <column>", ThoughtSpot sorts by the column, then takes the top n results. If you specify an attribute column, ThoughtSpot selects the results by reverse alphabetical order. We recommend using measure columns with the "top n by" keyword.
- Examples
-
top 10 sales rep revenue top sales rep by count sales for average revenue > 10000 sales rep average revenue for each region top
- 中文 (繁體)
-
頂部
- top n … ranked by
-
Ranks the top n items by a specified measure. The
ranked by
keyword only works in conjunction with thetop
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
- 中文 (繁體)
-
底部
- 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
- 中文 (繁體)
-
按…… 排序
- 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
-
sales April
- 中文 (繁體)
-
四月
- August
-
- Example
-
sales August
- 中文 (繁體)
-
八月
- before
-
- Example
-
order date before 03/01/2014
- 中文 (繁體)
-
在……之前
- between ... and ...
-
- Example
-
order date between 01/30/2012 and 01/30/2014
- 中文 (繁體)
-
在……之间 和
- daily
-
- Example
-
shipments by region daily
- 中文 (繁體)
-
每日
- daily year-over-year
-
- Example
-
growth of revenue by order date daily year-over-year
- 中文 (繁體)
-
每日 年度同比
- day
-
- Example
-
revenue 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
-
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
-
sales December
- 中文 (繁體)
-
十二月
- February
-
- Example
-
sales February
- 中文 (繁體)
-
二月
- Friday
-
- Example
-
sales 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
-
sales January
- 中文 (繁體)
-
一月
- July
-
- Example
-
sales July
- 中文 (繁體)
-
七月
- June
-
- Example
-
sales 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
-
sales March
- 中文 (繁體)
-
三月
- May
-
- Example
-
sales May
- 中文 (繁體)
-
五月
- Monday
-
- Example
-
sales 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 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
-
opportunities next n days for each month
- 中文 (繁體)
-
下一個 n 天 對於每個月
- next n days for each quarter
-
- Example
-
opportunities next 15 days for each quarter
- 中文 (繁體)
-
下一個 n 天 為每個 季度
- next n days for each week
-
- Example
-
opportunities next 2 days for each week
- 中文 (繁體)
-
下一個 n 天 為每個 星期
- next n days for each year
-
- Example
-
opportunities next 300 days for each year
- 中文 (繁體)
-
下一個 n 天 為每個 年
- next n months
-
- Example
-
openings next 6 months location
- 中文 (繁體)
-
下一個 n 月
- next n months for each quarter
-
- Example
-
projected cost next 2 months for each quarter
- 中文 (繁體)
-
下一個 n 月 為每個 季度
- next n months for each year
-
- Example
-
projected cost 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
-
projected 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
-
meetings next 3 weeks for each month
- 中文 (繁體)
-
下一個 n 星期 為每個 月
- next n weeks for each quarter
-
- Example
-
meetings next 2 weeks for each quarter
- 中文 (繁體)
-
下一個 n 星期 為每個 季度
- next n weeks for each year
-
- Example
-
meetings next 3 weeks for each year
- 中文 (繁體)
-
下一個 n 星期 為每個 年
- next n years
-
- Example
-
projected deals next 5 years
- 中文 (繁體)
-
下一個 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
-
sales November
- 中文 (繁體)
-
十一月
- October
-
- Example
-
sales October
- 中文 (繁體)
-
十月
- 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
-
sales Saturday
- 中文 (繁體)
-
週六
- September
-
- Example
-
sales September
- 中文 (繁體)
-
九月
- Sunday
-
- Example
-
sales 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
-
sales Thursday
- 中文 (繁體)
-
週四
- today
-
- Example
-
sales today by store
- 中文 (繁體)
-
今天
- Tuesday
-
- Example
-
sales Tuesday
- 中文 (繁體)
-
週二
- Wednesday
-
- Example
-
sales 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
- 中文 (繁體)
-
每小時
- hour of day
-
- Example
-
visitors by page name hour of day
- 中文 (繁體)
-
某天中的某個小時
- last hour
-
- Example
-
count unique visits last hour
- 中文 (繁體)
-
上一個 小時
- last minute
-
- Example
-
count homepage views last minute
- 中文 (繁體)
-
上一個 分鐘
- last n hours
-
- Example
-
sales last 2 hours
- 中文 (繁體)
-
上一個 n 小時
- last n minutes
-
- Example
-
count homepage views last 30 minutes
- 中文 (繁體)
-
上一個 n 分鐘
- last n seconds
-
- Example
-
count homepage views last 30 seconds
- 中文 (繁體)
-
上一個 n 秒
- last second
-
- Example
-
count homepage views last second
- 中文 (繁體)
-
上一個 秒
- 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 分鐘 …… 以前
- n seconds
-
- Example
-
count visitors [ last | next ] 30 seconds
- 中文 (繁體)
-
n 秒
- n seconds ago
-
- Example
-
sum inventory by product 10 seconds ago
- 中文 (繁體)
-
n 秒 …… 以前
- next hour
-
- Example
-
count projected visitors next hour
- 中文 (繁體)
-
下一個 小時
- next minute
-
- Example
-
count projected visitors next minute
- 中文 (繁體)
-
下一個 分鐘
- next n hours
-
- Example
-
count projected visitors next 2 hours
- 中文 (繁體)
-
下一個 n 小時
- next n minutes
-
- Example
-
count projected visitors next 30 minutes
- 中文 (繁體)
-
下一個 n 分鐘
- next n seconds
-
- Example
-
count projected visitors next 30 seconds
- 中文 (繁體)
-
下一個 n 秒
- next second
-
- Example
-
count projected visitors next second
- 中文 (繁體)
-
下一個 秒
- this hour
-
- Example
-
count visitors this hour
- 中文 (繁體)
-
這個 小時
- this minute
-
- Example
-
count visitors this minute
- 中文 (繁體)
-
這個 分鐘
- this second
-
- Example
-
count visitors this second
- 中文 (繁體)
-
這個 秒
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 returnbeginner 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
orsport set
, but they wouldn’t returnbeginner sport set
.product name begins with 'pro' 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 withand
. - 中文 (繁體)
-
以……开始
- contains
-
- Examples
-
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 usingor
logic. Prior to ThoughtSpot version 9.2.0.cl, ThoughtSpot combined these phrases usingand
logic. If you have existing Answers or visualizations using thisand
logic, ThoughtSpot will automatically update your queries after you upgrade to 9.2.0.cl, 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 returnNorth America
. - 中文 (繁體)
-
包含
- ends with
-
- Examples
-
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 returndeluxe 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
orbath towels luxury
, but they wouldn’t returndeluxe bath towels
.ends with
phrases can’t be combined withand
. - 中文 (繁體)
-
以……结束
- similar to
-
- Examples
-
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 returnt-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
orwhite t-shirt
, but they wouldn’t returngreen hat
.similar to
phrases can’t be combined withand
. - 中文 (繁體)
-
類似於
- not begins with
-
- Examples
-
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 returnpro 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 returnpro sport set
orsport set
. - 中文 (繁體)
-
不以……開始
- not contains
-
- Examples
-
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 returnNorth America
orAzerbaijan
.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 notAzerbaijan
. - 中文 (繁體)
-
不包含
- not ends with
-
- Examples
-
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 returnbath 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 returnbath towels luxury
orbath 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 returnjean 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 returnjean jacket men’s
ort-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
-
order date between 01/30/2012 and 01/30/2014
- 中文 (繁體)
-
在… 和… 之间
=
(equal)-
- Example
-
unique count visitor by store purchased products = 3 for last 5 days
You can use special constants for null and empty values with the
=
and!=
keywords:{null}
and{empty}
. For example:customer name = {empty}
ordepartment != {null}
. NULL values are missing or invalid (for example, dividing by 0) values. ThoughtSpot also shows NULL if you haven/a
in your data. Empty values are empty strings of text or strings containing only whitespace (spaces, tabs). - 中文 (繁體)
-
=
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
You can use special constants for null and empty values with the
=
and!=
keywords:{null}
and{empty}
. For example:customer name = {empty}
ordepartment != {null}
. NULL values are missing or invalid (for example, dividing by 0) values. ThoughtSpot also shows NULL if you haven/a
in your data. Empty values are empty strings of text or strings containing only whitespace (spaces, tabs). - 中文 (繁體)
-
!=
vs
,versus
-
- Example
-
revenue east vs west state name begins_with 'a' state name begins_with 'c' vs state name begins_with 'd'
ThoughtSpot supports use of multiple contains
,begins_with
, andends_with
phrases invs
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 multiplebegins_with
orends_with
phrases on the same side of theversus
query, ThoughtSpot will combine them usingOR
. For multiplecontains
phrases on the same side of theversus
query, ThoughtSpot will combine them usingOR
orAND
, depending on the behavior set in your environment.ThoughtSpot doesn’t support the use of group_* formula measures with the vs
keyword. ThoughtSpot doesn’t support the use of thevs
keyword within anin
ornot 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
- 中文 (繁體)
-
天 (date)
- day of month
-
- Example
-
sales day of month by month
- 中文 (繁體)
-
某月中的某天 (date)
- day of quarter
-
- Example
-
deals day of quarter by year
- 中文 (繁體)
-
某季度中的某天 (date)
- day of week
-
- Example
-
customers by week day of week
- 中文 (繁體)
-
週中 (date)
- day of year
-
- Example
-
ad clicks day of year by year
- 中文 (繁體)
-
某年中的某天 (date)
- hour
-
- Example
-
visitors by hour weekly
- 中文 (繁體)
-
小時 (datetime)
- month of quarter
-
- Example
-
purchases month of quarter by year
- 中文 (繁體)
-
某季度的某月 (date)
- quarter
-
- Example
-
purchases by quarter
- 中文 (繁體)
-
季度 (date)
- quarter of year
-
- Example
-
opportunities quarter of year last 4 years yearly
- 中文 (繁體)
-
某年的某季度 (date)
- 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.
- 中文 (繁體)
-
某月中某星期 (date)
- 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. - 中文 (繁體)
-
某季度中某星期 (date)
- 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. - 中文 (繁體)
-
某年中某星期 (date)
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
- 中文 (繁體)
-
不在