日本語 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 as top 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
日本語

トップ 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.

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
日本語

by (no translation)

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
日本語
  • 4月

  • april

August
Example
sales August
日本語
  • 8月

  • 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
日本語
  • 12月

  • december

February
Example
sales February
日本語
  • 2月

  • february

Friday
Example
sales Friday
日本語
  • 金曜日

  • 金曜

  • 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
日本語
  • 1月

  • january

July
Example
sales July
日本語
  • 7月

  • july

June
Example
sales June
日本語
  • 6月

  • june

last day by
Example
customers last day by referrer
日本語
  • 先日

  • 前の日

  • 前日

  • 1日前

  • last day

last day for each month
Example
sales last day for each month
日本語

月の最終日

last day for each quarter
Example
revenue last day for each quarter
日本語

四半期の最終日

last day for each week
Example
total sold last day for each week
日本語

週の最終日

last day for each year
Example
revenue last day for each year
日本語

年の最終日

last month
Example
customers last month by store
日本語
  • 先月

  • 前の月

  • 前月

  • 1か月前

  • 1ヶ月前

  • 1ケ月前

  • 1ヵ月前

  • 1カ月前

  • last month

last month by
Example
customers last month by day
日本語
  • 先月

  • 前の月

  • 前月

  • 1か月前

  • 1ヶ月前

  • 1ケ月前

  • 1ヵ月前

  • 1カ月前

  • last month

last month for each quarter
Example
customers last month for each quarter
日本語

四半期の最終月

last month for each year
Example
customers last month for each year
日本語

年の最終月

last n days
Example
visitors last 7 days
日本語
  • 過去 n

  • 過去 n 日間

  • last n days

last n days for each month
Example
sales last 2 days for each month
日本語
  • 月毎の最後の n

  • 月ごとの最後の n

  • last n days for each month

last n days for each quarter
Example
revenue last 15 days for each quarter
日本語
  • 四半期毎の最後の n

  • 四半期ごとの最後の n

  • last n days for each quarter

last n days for each week
Example
total sold last 2 days for each week
日本語
  • 週毎の最後の n

  • 週ごとの最後の n

  • last n days for each week

last n days for each year
Example
revenue last 300 days for each year
日本語
  • 年毎の最後の n

  • 年ごとの最後の n

  • last n days for each year

last n hours for each day
Example
sales last 2 hours for each day
日本語
  • 日毎の最後の n 時間

  • 日ごとの最後の n 時間

  • last n hours for each day

last n months
Example
visitors last 10 months by day
日本語
  • 過去 n

  • 過去 n か月

  • last n months

last n months for each quarter
Example
cost last 2 months for each quarter
日本語
  • 四半期毎の最後の n か月

  • 四半期毎の最後の n ヶ月

  • 四半期毎の最後の n ケ月

  • 四半期毎の最後の n ヵ月

  • 四半期毎の最後の n カ月

  • 四半期ごとの最後の n か月

  • 四半期ごとの最後の n ヶ月

  • 四半期ごとの最後の n ケ月

  • 四半期ごとの最後の n ヵ月

  • 四半期ごとの最後の n カ月

  • last n months for each quarter

last n months for each year
Example
last 8 months for each year
日本語
  • 年毎の最後の n か月

  • 年毎の最後の n ヶ月

  • 年毎の最後の n ケ月

  • 年毎の最後の n ヵ月

  • 年毎の最後の n カ月

  • 年ごとの最後の n か月

  • 年ごとの最後の n ヶ月

  • 年ごとの最後の n ケ月

  • 年ごとの最後の n ヵ月

  • 年ごとの最後の n カ月

  • last n months for each year

last n quarters
Example
visitors last 2 quarters by month by campaign
日本語
  • 過去 n 四半期

  • 過去 n q

  • last n quarters

last n quarters for each year
Example
last 2 quarters for each year
日本語
  • 年毎の最後の n 四半期

  • 年ごとの最後の n 四半期

  • last n quarters for each year

last n weeks
Example
visitors last 10 weeks by day
日本語
  • 過去 n

  • 過去 n 週間

  • last n weeks

last n weeks for each month
Example
sales last 3 weeks for each month
日本語
  • 月毎の最後の n

  • 月ごとの最後の n

  • last n weeks for each month

last n weeks for each quarter
Example
last 2 weeks for each quarter
日本語
  • 四半期毎の最後の n

  • 四半期ごとの最後の n

  • last n weeks for each quarter

last n weeks for each year
Example
last 3 weeks for each year
日本語
  • 年毎の最後の n

  • 年ごとの最後の n

  • last n weeks for each year

last n years
Example
visitors last 5 years by revenue for sum revenue > 5000
日本語
  • 過去 n

  • 過去 n 年間

  • last n years

last quarter
Example
customers last quarter sale > 300
日本語
  • 前四半期

  • 先四半期

  • 前の四半期

  • 1四半期前

  • last quarter

last quarter for each year
Example
customers last quarter for each year
日本語
  • 年の最終四半期

  • last quarter for each year

last week
Example
customers last week by store
日本語
  • 先週

  • 前の週

  • 前週

  • 1週前

  • last week

last week for each month
Example
sales last week for each month
日本語
  • 月の最終週

  • last week for each month

last week for each quarter
Example
sales last week for each quarter
日本語
  • 四半期の最終週

  • last week for each quarter

last week for each year
Example
sales last week for each year
日本語
  • 年の最終週

  • last week for each year

last year
Example
top 10 customers last year by sale by store for region west
日本語
  • 去年

  • 昨年

  • 前の年

  • 前年

  • 1年前

  • last year

March
Example
sales March
日本語
  • 3月

  • march

May
Example
sales May
日本語
  • 5月

  • may

Monday
Example
sales Monday
日本語
  • 月曜日

  • 月曜

  • monday

month
Example
revenue by month last year
日本語

month
Example
commission January
日本語

month to date
Example
sales by product month to date sales > 2400
日本語
  • 月初から今日まで

  • 月初から本日まで

  • 月累計

  • mtd

  • month to date

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 days ago

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 ヶ月前

  • n ケ月前

  • n ヵ月前

  • n カ月前

  • n months ago

n quarters ago
Example
sales 4 quarters ago by product name contains deluxe
日本語
  • n 四半期前

  • n quarters ago

n weeks ago
Example
sales 4 weeks ago by store
日本語
  • n 週前

  • n weeks ago

n years
Example
opportunities next 5 years by revenue
日本語

n

n years ago
Example
sales 5 years ago by store for region west
日本語
  • n 年前

  • n years ago

next day
Example
shipments next day by order
日本語
  • 翌日

  • 次の日

  • 1日後

  • next day

next month
Example
appointments next month by day
日本語
  • 来月

  • 次の月

  • 翌月

  • 次月

  • 1か月後

  • 1ヶ月後

  • 1ケ月後

  • 1ヵ月後

  • 1カ月後

  • next month

next n days
Example
shipments next 7 days
日本語
  • 次の n

  • 次の n 日間

  • next n days

next n months
Example
openings next 6 months location
日本語
  • 次の n か月

  • 次の n ヶ月

  • 次の n ケ月

  • 次の n ヵ月

  • 次の n カ月

  • next n months

next n quarters
Example
opportunities next 2 quarters by campaign
日本語
  • 次の n 四半期

  • 次の n q

  • next n quarters

next n weeks
Example
shipments next 10 weeks by day
日本語
  • 次の n

  • 次の n 週間

  • next n weeks

next n years
Example
projected deals next 5 years
日本語
  • 次の n 年

  • 次の n 年間

  • next n years

next quarter
Example
opportunities next quarter amount > 30000
日本語
  • 来四半期

  • 次の四半期

  • 翌四半期

  • 次四半期

  • 1四半期後

  • next quarter

next week
Example
shipments next week by store
日本語
  • 来週

  • 次の週

  • 翌週

  • 次週

  • 1週後

  • 1週間後

  • next week

next year
Example
opportunities next year by sales rep
日本語
  • 来年

  • 次の年

  • 翌年

  • 次年

  • 1年後

  • next year

November
Example
sales November
日本語
  • 11月

  • november

October
Example
sales October
日本語
  • 10月

  • october

quarter to date
Example
sales by product quarter to date
  for top 10 products by sales
日本語
  • 四半期初から今日まで

  • 四半期初から本日まで

  • 四半期累計

  • qtd

  • quarter to date

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
日本語
  • 土曜日

  • 土曜

  • saturday

September
Example
sales September
日本語
  • 9月

  • september

Sunday
Example
sales Sunday
日本語
  • 日曜日

  • 日曜

  • 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
日本語
  • 木曜日

  • 木曜

  • thursday

today
Example
sales today by store
日本語
  • 今日

  • today

Tuesday
Example
sales Tuesday
日本語
  • 火曜日

  • 火曜

  • tuesday

Wednesday
Example
sales Wednesday
日本語
  • 水曜日

  • 水曜

  • wednesday

week
Example
revenue by week last quarter
日本語

week to date
Example
sales by order date week to date for pro-ski200
日本語
  • 週初から今日まで

  • 週初から本日まで

  • 週累計

  • wtd

  • week to date

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
日本語
  • 年初から今日まで

  • 年初から本日まで

  • 年累計

  • ytd

  • year to date

yearly
Example
shipments by product yearly
日本語

年単位

yesterday
Example
sales yesterday for pro-ski200 by store
日本語
  • 昨日

  • yesterday

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
日本語
  • 1時間前

  • 前の時間

  • last hour

last minute
Example
count homepage views last minute
日本語
  • 1分前

  • 前の分

  • last minute

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 hours ago

n minutes
Example
count visitors [ last | next ] 30 minutes
日本語

n

n minutes ago
Example
sum inventory by product 10 minutes ago
日本語
  • n 分前

  • n minutes ago

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 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'
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
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 using or logic. Prior to ThoughtSpot version 9.2.0.cl, 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.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 return North 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 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
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 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
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 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
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 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
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 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

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

日本語

=

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

日本語

!=

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, 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 begins_with or ends_with phrases on the same side of the versus query, ThoughtSpot will combine them using OR. For multiple contains phrases on the same side of the versus query, ThoughtSpot will combine them using OR or AND, 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 the vs keyword within an in or not in subquery.
日本語

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.
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
日本語

in

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?