Deutsch (Switzerland) 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 Deutsch (Switzerland), you can only use Deutsch (Switzerland) 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.
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
Deutsch (Switzerland)

untere n

by measure

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

Examples
cost by revenue

product by quantity purchased
Deutsch (Switzerland)

per

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
Deutsch (Switzerland)

sortieren nach

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
Deutsch (Switzerland)

obere 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
Deutsch (Switzerland)

obere n …​ platziert nach

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
Deutsch (Switzerland)

nach dem

April
Example
sales April
Deutsch (Switzerland)

april

August
Example
sales August
Deutsch (Switzerland)

august

before
Example
order date before 03/01/2014
Deutsch (Switzerland)

vor dem

between ... and ...
Example
order date between 01/30/2012 and 01/30/2014
Deutsch (Switzerland)

zwischen dem … und dem …​

daily
Example
shipments by region daily
Deutsch (Switzerland)

täglich

daily year-over-year
Example
growth of revenue by order date daily year-over-year
Deutsch (Switzerland)

täglich im Jahresvergleich

day
Example
revenue by day
Deutsch (Switzerland)

Tag

day of month
Example
sales day of month by month
Deutsch (Switzerland)

Tag des Monats

day of quarter
Example
deals day of quarter by year
Deutsch (Switzerland)

Tag des Quartals

day of week
Example
revenue by day of week last 6 months
Deutsch (Switzerland)

Tag der Woche

day of week
Example
count shipments Monday
Deutsch (Switzerland)

Tag der Woche

day of year
Example
ad clicks day of year by year
Deutsch (Switzerland)

Tag des Jahres

December
Example
sales December
Deutsch (Switzerland)

dezember

February
Example
sales February
Deutsch (Switzerland)

februar

Friday
Example
sales Friday
Deutsch (Switzerland)

fritig

growth of …​ by ...
Example
growth of sales by order date
Deutsch (Switzerland)

Wachstum von … per…​

growth of …​ by …​ daily
Example
growth of sales by order date daily
Deutsch (Switzerland)

Wachstum von … per…​ täglich

growth of …​ by …​ monthly
Example
growth of sales by date shipped monthly sales > 24000
Deutsch (Switzerland)

Wachstum von … per … monatlich

growth of …​ by …​ quarterly
Example
growth of sales by date shipped quarterly
Deutsch (Switzerland)

Wachstum von … per … vierteljährlich

growth of …​ by …​ weekly
Example
growth of sales by receipt date weekly for pro-ski2000
Deutsch (Switzerland)

Wachstum von … per … wöchentlich

growth of …​ by …​ yearly
Example
growth of sales by date closed yearly
Deutsch (Switzerland)

Wachstum von … per … jährlich

January
Example
sales January
Deutsch (Switzerland)

januar

July
Example
sales July
Deutsch (Switzerland)

juli

June
Example
sales June
Deutsch (Switzerland)

juni

last day
Example
customers last day
Deutsch (Switzerland)
  • letzter Tag

  • letzten Tag

  • der letzte Tag

  • am letzten Tag

last day by
Example
customers last day by referrer
Deutsch (Switzerland)

letzter Tag per

Date phrase translations Beta
last day for each month
Example
sales last day for each month
Deutsch (Switzerland)
  • letzter Tag in jedem Monat

  • letzter Tag jedes Monats

  • am letzten Tag jedes Monats

last day for each quarter
Example
revenue last day for each quarter
Deutsch (Switzerland)
  • letzter Tag in jedem Quartal

  • letzter Tag jedes Quartals

  • am letzten Tag jedes Quartals

last day for each week
Example
total sold last day for each week
Deutsch (Switzerland)
  • letzter Tag in jeder Woche

  • letzter Tag jeder Woche

  • am letzten Tag jeder Woche

last day for each year
Example
revenue last day for each year
Deutsch (Switzerland)
  • letzter Tag in jedem Jahr

  • letzter Tag jedes Jahres

  • am letzten Tag jedes Jahres

last hour for each day
Example
count unique visits last hour for each day
Deutsch (Switzerland)
  • letzte Stunde an jedem Tag

  • letzte Stunde jedes Tages

  • in der letzten Stunde jedes Tages

last month
Example
customers last month by store
Deutsch (Switzerland)
  • letzter Monat

  • letzten Monat

  • der letzte Monat

  • im letzten Monat

last month by
Example
customers last month by day
Deutsch (Switzerland)

letzter Monat per

Date phrase translations Beta
last month for each quarter
Example
customers last month for each quarter
Deutsch (Switzerland)
  • letzter Monat in jedem Quartal

  • im letzten Monat jedes Quartals

  • im letzten Monat in jedem Quartal

last month for each year
Example
customers last month for each year
Deutsch (Switzerland)
  • letzter Monat in jedem Jahr

  • im letzten Monat jedes Jahres

  • im letzten Monat in jedem Jahr

last n days
Example
visitors last 7 days
Deutsch (Switzerland)
  • letzte n Tage

  • letzten n Tage

  • die letzten n Tage

  • in den letzten n Tagen

Date phrase translations Beta
last n days for each month
Example
sales last 2 days for each month
Deutsch (Switzerland)
  • letzten n Tage in jedem Monat

  • letzten n Tage jedes Monats

  • letzten n Tagen jedes Monats

  • letzten n Tagen in jedem Monat

last n days for each quarter
Example
revenue last 15 days for each quarter
Deutsch (Switzerland)
  • letzten n Tage in jedem Quartal

  • letzten n Tage jedes Quartals

  • letzten n Tagen jedes Quartals

  • letzten n Tagen in jedem Quartal

last n days for each week
Example
total sold last 2 days for each week
Deutsch (Switzerland)
  • letzten n Tage in jeder Woche

  • letzten n Tage jeder Woche

  • letzten n Tagen jeder Woche

  • letzten n Tagen in jeder Woche

last n days for each year
Example
revenue last 300 days for each year
Deutsch (Switzerland)
  • letzten n Tage in jedem Jahr

  • letzten n Tage jedes Jahres

  • letzten n Tagen jedes Jahres

  • letzten n Tagen in jedem Jahr

last n hours for each day
Example
sales last 2 hours for each day
Deutsch (Switzerland)
  • letzten n Stunden an jedem Tag

  • letzten n Stunden jedes Tages

last n months
Example
visitors last 10 months by day
Deutsch (Switzerland)
  • letzte n Monate

  • letzten n Monate

  • die letzten n Monate

  • in den letzten n Monaten

Date phrase translations Beta
last n months for each quarter
Example
cost last 2 months for each quarter
Deutsch (Switzerland)
  • letzten n Monate in jedem Quartal

  • letzten n Monate jedes Quartals

  • letzten n Monaten jedes Quartals

  • letzten n Monaten in jedem Quartal

last n months for each year
Example
last 8 months for each year
Deutsch (Switzerland)
  • letzten n Monate in jedem Jahr

  • letzten n Monate jedes Jahres

  • letzten n Monaten jedes Jahres

  • letzten n Monaten in jedem Jahr

last n quarters
Example
visitors last 2 quarters by month by campaign
Deutsch (Switzerland)
  • letzte n Quartale

  • letzten n Quartale

  • die letzten n Quartale

  • in den letzten n Quartalen

Date phrase translations Beta
last n quarters for each year
Example
last 2 quarters for each year
Deutsch (Switzerland)
  • letzten n Quartale in jedem Jahr

  • letzten n Quartale jedes Jahres

  • letzten n Quartalen jedes Jahres

  • letzten n Quartalen in jedem Jahr

last n weeks
Example
visitors last 10 weeks by day
Deutsch (Switzerland)
  • letzte n Wochen

  • letzten n Wochen

  • die letzten n Wochen

  • in den letzten n Wochen

Date phrase translations Beta
last n weeks for each month
Example
sales last 3 weeks for each month
Deutsch (Switzerland)
  • letzten n Wochen in jedem Monat

  • letzten n Wochen jedes Monats

last n weeks for each quarter
Example
last 2 weeks for each quarter
Deutsch (Switzerland)
  • letzten n Wochen in jedem Quartal

  • letzten n Wochen jedes Quartals

last n weeks for each year
Example
last 3 weeks for each year
Deutsch (Switzerland)
  • letzten n Wochen in jedem Jahr

  • letzten n Wochen jedes Jahres

last n years
Example
visitors last 5 years by revenue for sum revenue > 5000
Deutsch (Switzerland)
  • letzte _n Jahre

  • letzten n Jahre

  • die letzten n Jahre

  • in den letzten n Jahren

last quarter
Example
customers last quarter sale > 300
Deutsch (Switzerland)
  • letztes Quartal

  • letzte Quartal

  • das letzte Quartal

  • im letzten Quartal

Date phrase translations Beta
last quarter for each year
Example
customers last quarter for each year
Deutsch (Switzerland)
  • letztes Quartal in jedem Jahr

  • im letzten Quartal jedes Jahres

  • im letzten Quartal in jedem Jahr

last week
Example
customers last week by store
Deutsch (Switzerland)
  • letzte Woche

  • die letzte Woche

  • in der letzten Woche

Date phrase translations Beta
last week for each month
Example
sales last week for each month
Deutsch (Switzerland)
  • letzte Woche in jedem Monat

  • in der letzten Woche jedes Monats

  • in der letzten Woche in jedem Monat

last week for each quarter
Example
sales last week for each quarter
Deutsch (Switzerland)
  • letzte Woche in jedem Quartal

  • in der letzten Woche jedes Quartals

  • in der letzten Woche in jedem Quartal

last week for each year
Example
sales last week for each year
Deutsch (Switzerland)
  • letzte Woche in jedem Jahr

  • in der letzten Woche jedes Jahres

  • in der letzten Woche in jedem Jahr

last year
Example
top 10 customers last year by sale by store for region west
Deutsch (Switzerland)
  • letztes Jahr

  • letzte Jahr

  • das letzte Jahr

  • im letzten Jahr

March
Example
sales March
Deutsch (Switzerland)

märz

May
Example
sales May
Deutsch (Switzerland)

dörf

Monday
Example
sales Monday
Deutsch (Switzerland)

mäntig

month
Example
revenue by month last year
Deutsch (Switzerland)

Monat

month
Example
commission January
Deutsch (Switzerland)

Monat

month to date
Example
sales by product month to date sales > 2400
Deutsch (Switzerland)

Monat bis heute

Date phrase translations Beta
month to date for each month
Example
sales by product month to date for each month
Deutsch (Switzerland)

Monat bis heute in jedem Monat

month to date for each quarter
Example
sales by product month to date for each quarter
Deutsch (Switzerland)

Monat bis heute in jedem Quartal

month to date for each year
Example
sales by product month to date for each year
Deutsch (Switzerland)

Monat bis heute in jedem Jahr

month year
Example
commission by sales rep February 2014
Deutsch (Switzerland)

Monat Jahr

monthly
Example
commission monthly
Deutsch (Switzerland)

monatlich

monthly year-over-year
Example
growth of revenue
  by receipt date
  monthly year-over-year
Deutsch (Switzerland)

monatlich im Jahresvergleich

n days ago
Example
sales 2 days ago
Deutsch (Switzerland)

vor n Tagen

n months
Example
visitors last 6 months for homepage visits > 30 by month
Deutsch (Switzerland)

n Monate(n)

n months ago
Example
sales 2 months ago by region
Deutsch (Switzerland)

vor n Monaten

n quarters ago
Example
sales 4 quarters ago by product name contains deluxe
Deutsch (Switzerland)

vor n Quartalen

n weeks ago
Example
sales 4 weeks ago by store
Deutsch (Switzerland)

vor n Wochen

n years
Example
opportunities next 5 years by revenue
Deutsch (Switzerland)

n Jahre

n years ago
Example
sales 5 years ago by store for region west
Deutsch (Switzerland)

vor n Jahren

next day
Example
shipments next day by order
Deutsch (Switzerland)
  • nächster Tag

  • nächsten Tag

  • der nächste Tag

  • am nächsten Tag

next month
Example
appointments next month by day
Deutsch (Switzerland)
  • nächster Monat

  • nächsten Monat

  • der nächste Monat

  • im nächsten Monat

next n days
Example
shipments next 7 days
Deutsch (Switzerland)
  • nächste n Tage

  • nächsten n Tage

  • die nächsten n Tage

  • in den nächsten n Tagen

Date phrase translations Beta
next n days for each month
Example
opportunities next n days for each month
Deutsch (Switzerland)

nächstes n Tage für jede(s/n) Monat

next n days for each quarter
Example
opportunities next 15 days for each quarter
Deutsch (Switzerland)

nächstes n Tage für jede(s/n) Quartal

next n days for each week
Example
opportunities next 2 days for each week
Deutsch (Switzerland)

nächstes n Tage für jede(s/n) Woche

next n days for each year
Example
opportunities next 300 days for each year
Deutsch (Switzerland)

nächstes n Tage für jede(s/n) Jahr

next n months
Example
openings next 6 months location
Deutsch (Switzerland)
  • nächste n Monate

  • nächsten n Monate

  • die nächsten n Monate

  • in den nächsten n Monaten

Date phrase translations Beta
next n months for each quarter
Example
projected cost next 2 months for each quarter
Deutsch (Switzerland)

nächstes n Monate für jede(s/n) Quartal

next n months for each year
Example
projected cost next 8 months for each year
Deutsch (Switzerland)

nächstes n Monate für jede(s/n) Jahr

next n quarters
Example
opportunities next 2 quarters by campaign
Deutsch (Switzerland)
  • nächste n Quartale

  • nächsten n Quartale

  • die nächsten n Quartale

  • in den nächsten n Quartalen

Date phrase translations Beta
next n quarters for each year
Example
projected sales next 2 quarters for each year
Deutsch (Switzerland)

nächstes n Quartale für jede(s/n) Jahr

next n weeks
Example
shipments next 10 weeks by day
Deutsch (Switzerland)
  • nächste n Wochen

  • nächsten n Wochen

  • die nächsten n Wochen

  • in den nächsten n Wochen

Date phrase translations Beta
next n weeks for each month
Example
meetings next 3 weeks for each month
Deutsch (Switzerland)

nächstes n Wochen für jede(s/n) Monat

next n weeks for each quarter
Example
meetings next 2 weeks for each quarter
Deutsch (Switzerland)

nächstes n Wochen für jede(s/n) Quartal

next n weeks for each year
Example
meetings next 3 weeks for each year
Deutsch (Switzerland)

nächstes n Wochen für jede(s/n) Jahr

next n years
Example
projected deals next 5 years
Deutsch (Switzerland)
  • nächste n Jahre

  • nächsten n Jahre

  • die nächsten n Jahre

  • in den nächsten n Jahren

next quarter
Example
opportunities next quarter amount > 30000
Deutsch (Switzerland)
  • nächstes Quartal

  • nächste Quartal

  • das nächste Quartal

  • im nächsten Quartal

next week
Example
shipments next week by store
Deutsch (Switzerland)
  • nächste Woche

  • die nächste Woche

  • in der nächsten Woche

next year
Example
opportunities next year by sales rep
Deutsch (Switzerland)
  • nächstes Jahr

  • nächste Jahr

  • das nächste Jahr

  • im nächsten Jahr

November
Example
sales November
Deutsch (Switzerland)

november

October
Example
sales October
Deutsch (Switzerland)

oktober

on or after
Example
order date on or after 10/31/2014
Deutsch (Switzerland)

am oder nach dem

on or before
Example
order date on or before 03/01/2014
Deutsch (Switzerland)

am oder vor dem

quarter to date
Example
sales by product quarter to date
  for top 10 products by sales
Deutsch (Switzerland)

Quartal bis heute

Date phrase translations Beta
quarter to date for each quarter
Example
sales by product quarter to date for each quarter
Deutsch (Switzerland)

Quartal bis heute in jedem Quartal

quarter to date for each year
Example
sales by product quarter to date for each year
Deutsch (Switzerland)

Quartal bis heute in jedem Jahr

quarterly
Example
sales quarterly for each product
Deutsch (Switzerland)

vierteljährlich

quarterly year-over-year
Example
growth of revenue by date shipped
quarterly year-over-year
Deutsch (Switzerland)

vierteljährlich im Jahresvergleich

Saturday
Example
sales Saturday
Deutsch (Switzerland)

samstig

September
Example
sales September
Deutsch (Switzerland)

september

Sunday
Example
sales Sunday
Deutsch (Switzerland)

sunntig

this day
Example
shipments this day by order
Deutsch (Switzerland)
  • dieser Tag

  • an diesem Tag

this month
Example
appointments this month by day
Deutsch (Switzerland)
  • dieser Monat

  • in diesem Monat

this quarter
Example
opportunities this quarter amount > 30000
Deutsch (Switzerland)
  • dieses Quartal

  • in diesem Quartal

this week
Example
shipments this week by store
Deutsch (Switzerland)
  • diese Woche

  • in dieser Woche

this year
Example
opportunities this year by sales rep
Deutsch (Switzerland)
  • dieses Jahr

  • in diesem Jahr

Thursday
Example
sales Thursday
Deutsch (Switzerland)

dunschtig

today
Example
sales today by store
Deutsch (Switzerland)

hüt

Tuesday
Example
sales Tuesday
Deutsch (Switzerland)

zischtig

Wednesday
Example
sales Wednesday
Deutsch (Switzerland)

mittwuch

week
Example
revenue by week last quarter
Deutsch (Switzerland)

Woche

week to date
Example
sales by order date week to date for pro-ski200
Deutsch (Switzerland)

Woche bis heute

Date phrase translations Beta
week to date for each month
Example
sales by order date week to date for each month
Deutsch (Switzerland)

Woche bis heute in jedem Monat

week to date for each quarter
Example
sales by order date week to date for each quarter
Deutsch (Switzerland)

Woche bis heute in jedem Quartal

week to date for each week
Example
sales by order date week to date for each week
Deutsch (Switzerland)

Woche bis heute in jeder Woche

week to date for each year
Example
sales by order date week to date for each year
Deutsch (Switzerland)

Woche bis heute in jedem Jahr

weekly
Example
revenue weekly
Deutsch (Switzerland)

wöchentlich

weekly year-over-year
Example
growth of revenue by date shipped
  weekly year-over-year
Deutsch (Switzerland)

wöchentlich im Jahresvergleich

year
Example
revenue by product 2014 product name contains snowboard
Deutsch (Switzerland)

Jahr

year to date
Example
sales by product year to date
Deutsch (Switzerland)

Jahr bis heute

Date phrase translations Beta
year to date for each year
Example
sales by product year to date for each year
Deutsch (Switzerland)

Jahr bis heute in jedem Jahr

yearly
Example
shipments by product yearly
Deutsch (Switzerland)

jährlich

yesterday
Example
sales yesterday for pro-ski200 by store
Deutsch (Switzerland)

Gestern

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
Deutsch (Switzerland)

detailliert

hourly
Example
visitors by page name hourly
Deutsch (Switzerland)

stündlich

hour of day
Example
visitors by page name hour of day
Deutsch (Switzerland)

Stunde des Tages

last hour
Example
count unique visits last hour
Deutsch (Switzerland)
  • letzte Stunde

  • die letzte Stunde

  • in der letzten Stunde

last minute
Example
count homepage views last minute
Deutsch (Switzerland)
  • letzte Minute

  • die letzte Minute

  • in der letzten Minute

last n hours
Example
sales last 2 hours
Deutsch (Switzerland)
  • letzte n Stunden

  • letzten n Stunden

  • die letzten n Stunden

  • in den letzten n Stunden

last n minutes
Example
count homepage views last 30 minutes
Deutsch (Switzerland)
  • letzte n Minuten

  • letzten n Minuten

  • die letzten n Minuten

  • in den letzten n Minuten

last n seconds
Example
count homepage views last 30 seconds
Deutsch (Switzerland)
  • letzte n Sekunden

  • letzten n Sekunden

  • die letzten n Sekunden

  • in den letzten n Sekunden

last second
Example
count homepage views last second
Deutsch (Switzerland)
  • letzte Sekunde

  • die letzte Sekunde

  • in der letzten Sekunde

n hours
Example
count visitors [ last | next ] 12 hours
Deutsch (Switzerland)

n Stunden

n hours ago
Example
sum inventory by product by store 2 hours ago
Deutsch (Switzerland)

vor n Stunden

n minutes
Example
count visitors [ last | next ] 30 minutes
Deutsch (Switzerland)

vor n Minuten

n minutes ago
Example
sum inventory by product 10 minutes ago
Deutsch (Switzerland)

n Minuten vorher

n seconds
Example
count visitors [ last | next ] 30 seconds
Deutsch (Switzerland)

n Sekunden

n seconds ago
Example
sum inventory by product 10 seconds ago
Deutsch (Switzerland)

vor n Sekunden

next hour
Example
count projected visitors next hour
Deutsch (Switzerland)
  • nächste Stunde

  • die nächste Stunde

  • in der nächsten Stunde

next minute
Example
count projected visitors next minute
Deutsch (Switzerland)
  • nächstes Minute

  • die nächste Minute

  • in der nächsten Minute

next n hours
Example
count projected visitors next 2 hours
Deutsch (Switzerland)
  • nächste n Stunden

  • nächsten n Stunden

  • die nächsten n Stunden

  • in den nächsten n Stunden

next n minutes
Example
count projected visitors next 30 minutes
Deutsch (Switzerland)
  • nächste n Minuten

  • nächsten n Minuten

  • die nächsten n Minuten

  • in den nächsten n Minuten

next n seconds
Example
count projected visitors next 30 seconds
Deutsch (Switzerland)
  • nächste n Sekunden

  • nächsten n Sekunden

  • die nächsten n Sekunden

  • in den nächsten n Sekunden

next second
Example
count projected visitors next second
Deutsch (Switzerland)
  • nächste Sekunde

  • die nächste Sekunde

  • in der nächsten Sekunde

this hour
Example
count visitors this hour
Deutsch (Switzerland)
  • diese Stunde

  • in dieser Stunde

this minute
Example
count visitors this minute
Deutsch (Switzerland)
  • diese Minute

  • in dieser Minute

this second
Example
count visitors this second
Deutsch (Switzerland)
  • diese Sekunde

  • in dieser Sekunde

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.

Deutsch (Switzerland)

beginnt mit

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.

Deutsch (Switzerland)

enthält

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.

Deutsch (Switzerland)

endet mit

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.

Deutsch (Switzerland)

ähnlich wie

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.

Deutsch (Switzerland)

beginnt nicht mit

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.

Deutsch (Switzerland)

enthält nicht

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.

Deutsch (Switzerland)

endet nicht mit

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.

Deutsch (Switzerland)

nicht ähnlich wie

Number

average
Example
average revenue by store
Deutsch (Switzerland)

Durchschnittlich

count
Example
count visitors by site
Deutsch (Switzerland)

Anzahl

for
Example
revenue by store by campaign for cost > 5000
Deutsch (Switzerland)

für

max
Example
max sales by visitor by site
Deutsch (Switzerland)

Maximum

min
Example
min revenue by store by campaign for cost > 5000
Deutsch (Switzerland)

Minimum

standard deviation
Example
standard deviation revenue by product by month for date after
10/31/2010
Deutsch (Switzerland)

Standardabweichung

sum
Example
sum revenue
Deutsch (Switzerland)

Summe

unique count
Example
unique count visitor by product page last week
Deutsch (Switzerland)

eindeutige Anzahl

variance
Example
variance sale amount by visitor by product for last year
Deutsch (Switzerland)

Varianz

Comparative

all
Example
revenue asia vs all
The all keyword can only be used as part of a versus phrase.
Deutsch (Switzerland)

alle

between... and...
Example
revenue between 0 and 1000
Deutsch (Switzerland)

zwischen … und

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

Deutsch (Switzerland)

=

everything
Example
revenue asia vs everything
The everything keyword can only be used as part of a versus phrase.
Deutsch (Switzerland)

alles

> (greater than)
Example
sum sale amount by visitor by product for last year sale amount > 2000
Deutsch (Switzerland)

>

>= (greater than or equal)
Example
count calls by employee lastname >= 'm'
Deutsch (Switzerland)

>=

< (less than)
Example
unique count visitor by product by store for sale amount < 20
Deutsch (Switzerland)

<

<= (less than or equal)
Example
count shipments by city latitude <= 0
Deutsch (Switzerland)

<=

!= (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).

Deutsch (Switzerland)

!=

of

Level of detail keyword. Returns the specified measure at the level of detail specified in the query.

Syntax
revenue of region
Deutsch (Switzerland)

von

percentage of

Used to specify mix, contribution, share of, percentage, and total ratios.

Syntax
state revenue percentage of region
Deutsch (Switzerland)

Prozentsatz von

total
Example
visitors total by product page last week
Deutsch (Switzerland)

insgesamt

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.
Deutsch (Switzerland)

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.
farther than n miles|km|meters from …​
Example
average hours worked branch farther than 80 km from scarborough
Deutsch (Switzerland)

weiter als n Meile/Kilometer/Meter von

near
Example
revenue store name county near san francisco
Deutsch (Switzerland)

nahe

near …​ within n miles|km|meters
Example
revenue store name county near alameda within 50 miles
Deutsch (Switzerland)

nahe …​ innerhalb von n Meile/Kilometer/Meter von

Period

day
Example
orders by day
Deutsch (Switzerland)

Tag (date)

day of month
Example
sales day of month by month
Deutsch (Switzerland)

Tag des Monats (date)

day of quarter
Example
deals day of quarter by year
Deutsch (Switzerland)

Tag des Quartals (date)

day of week
Example
customers by week day of week
Deutsch (Switzerland)

Tag der Woche (date)

day of year
Example
ad clicks day of year by year
Deutsch (Switzerland)

Tag des Jahres (date)

hour
Example
visitors by hour weekly
Deutsch (Switzerland)

Stunde (datetime)

month of quarter
Example
purchases month of quarter by year
Deutsch (Switzerland)

Monat des Quartals (date)

quarter
Example
purchases by quarter
Deutsch (Switzerland)

Quartal (date)

quarter of year
Example
opportunities quarter of year last 4 years yearly
Deutsch (Switzerland)

Quartal des Jahres (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.  
Deutsch (Switzerland)

Woche des Monats (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.
Deutsch (Switzerland)

Woche des Quartals (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.
Deutsch (Switzerland)

Woche des Jahres (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
Deutsch (Switzerland)

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

Deutsch (Switzerland)

nicht in


Was this page helpful?