Svenska keyword reference

Use keywords to help define a search.

This content is still under review, and might have incremental changes until this message is removed.

You can use keywords when asking a question to help define your search. This reference lists the various keywords. You can also see this list of keywords and examples from within the help center.

< Back to English Keywords page

General

English Keywords	Svenska Keywords	Examples
top	topp	`top sales rep by count sales for average revenue > 10000` `sales rep average revenue for each region top`
bottom	botten	`bottom revenue average` `bottom revenue by state` `customer by revenue for each sales rep bottom`
n	n	`top 10 sales rep revenue`
n	n	`bottom 25 customer by revenue for each sales rep`
sort by	sortera efter	`revenue by state sort by average revenue` `revenue by customer sort by region`

Date

English Keywords	Svenska Keywords	Examples
after	efter	`order date after 10/31/2014`
before	före	`order date before 03/01/2014`
between … and ...	mellan … och …	`order date between 01/30/2012 and 01/30/2014`
daily year-over-year	dagligen år-för-år	`growth of revenue by order date daily year-over-year`
daily	dagligen	`shipments by region daily`
day	dag	`count monday restaurant`
day of week	veckodag	`revenue by day of week last 6 months`
day of week	veckodag	`count shipments Monday`
n days for each month	n dagar för varje månad	`sales last 2 days for each month`
n days for each quarter	n dagar för varje kvartal	`revenue last 15 days for each quarter`
n days for each week	n dagar för varje vecka	`total sold last 2 days for each week`
n days for each year	n dagar för varje år	`revenue last 300 days for each year`
growth of … by … daily	tillväxt för … från … dagligen	`growth of sales by order date daily`
growth of … by … monthly	tillväxt för … från … månadsvis	`growth of sales by date shipped monthly sales > 24000`
growth of … by … quarterly	tillväxt för … från … kvartalsvis	`growth of sales by date shipped quarterly`
growth of … by … weekly	tillväxt för … från … veckovis	`growth of sales by receipt date weekly for pro-ski2000`
growth of … by … yearly	tillväxt för … från … årligen	`growth of sales by date closed yearly`
growth of … by ...	tillväxt för … från …	`growth of sales by order date`
n hours for each day	n timmar för varje dag	`sales last 2 hours for each day`
last day by	senaste dag från	`customers last day by referrer`
hourly	timvis	`visitors by page name hourly`
last month by	senaste månad från	`customers last month by day`
last n days	senaste n dagar	`visitors last 7 days`
last n quarters	senaste n kvartal	`visitors last 2 quarters by month by campaign`
last n weeks	senaste n veckor	`visitors last 10 weeks by day`
last quarter	senaste kvartal	`customers last quarter sale >300`
last week	senaste vecka	`customers last week by store`
last year	senaste år	`top 10 customers last year by sale by store for region west`
last n years	senaste n år	`visitors last 5 years by revenue for sum revenue >5000`
month to date	månad till datum	`sales by product month to date sales > 2400`
month year	månad år	`commission by sales rep February 2014`
month	månad	`commission January`
month	månad	`revenue by month last year`
monthly year-over-year	månadsvis år-för-år	`growth of revenue by receipt date monthly year-over-year`
monthly	månadsvis	`commission > 10000 monthly`
n months for each quarter	n månader för varje kvartal	`cost last 2 months for each quarter`
n months for each year	n månader för varje år	`last 8 months for each year`
n days ago	n dagar sedan	`sales 2 days ago`
n months ago	n månader sedan	`sales 2 months ago by region`
n months	n månader	`visitors last 6 months for homepage visits > 30 by month`
n quarters ago	n kvartal sedan	`sales 4 quarters ago by product name contains "deluxe"`
n weeks ago	n veckor sedan	`sales 4 weeks ago by store`
n years ago	n år sedan	`sales 5 years ago by store for region west`
n years	n år	`opportunities next 5 years by revenue`
next day	nästa dag	`shipments next day by order`
next month	nästa månad	`appointments next month by day`
next n days	nästa n dagar	`shipments next 7 days`
next n months	nästa n månader	`openings next 6 months location`
next n quarters	nästa n kvartal	`opportunities next 2 quarters by campaign`
next n weeks	nästa n veckor	`shipments next 10 weeks by day`
next quarter	nästa kvartal	`opportunities next quarter amount > 30000`
next week	nästa vecka	`shipments next week by store`
next year	nästa år	`opportunities next year by sales rep`
quarter to date	kvartal till datum	`sales by product quarter to date for top 10 products by sales`
quarterly year-over-year	kvartalsvis år-för-år	`growth of revenue by date shipped quarterly year-over-year`
quarterly	kvartalsvis	`sales quarterly for each product`
n quarters for each year	n kvartal för varje år	`last 2 quarters for each year`
today	idag	`sales today by store`
week to date	vecka till datum	`sales by order date week to date for pro-ski200`
week	vecka	`revenue by week last quarter`
weekly year-over-year	veckovis år-för-år	`growth of revenue by date shipped weekly year-over-year`
weekly	veckovis	`revenue weekly`
n weeks for each month	n veckor för varje månad	`sales last 3 weeks for each month`
n weeks for each quarter	n veckor för varje kvartal	`last 2 weeks for each quarter`
n weeks for each year	n veckor för varje år	`last 3 weeks for each year`
year to date	år till datum	`sales by product year to date`
year	år	`revenue by product 2014 product name contains "snowboard"`
yearly	årligen	`shipments by product yearly`
yesterday	igår	`sales yesterday for pro-ski200 by store`

Time

English Keywords	Svenska Keywords	Examples
detailed	detaljerad	`ship time detailed`
last minute	senaste minut	`count homepage views last minute`
last hour	senaste timme	`count unique visits last hour`
n minutes	n minuter	`count visitors last 30 minutes`
n hours	n timmar	`count visitors last 12 hours`
n minutes ago	n minuter sedan	`sum inventory by product 10 minutes ago`
n hours ago	n timmar sedan	`sum inventory by product by store 2 hours ago`

Text

English Keywords	Svenska Keywords	Examples
begins with	börjar med	`product name begins with 'pro'`
contains	innehåller	`product name contains "alpine" description contains "snow shoe"`
ends with	slutar mer	`product name ends with 'deluxe'`
not begins with	inte börjar med	`product name not begins with "tom's"`
not contains	inte innehåller	`product color not contains 'tan' product color not contains 'red'`
not ends with	inte slutar med	`product name not ends with "trial"`
similar to	liknar	`course name similar to 'hand'`
not similar to	inte liknar	`course name not similar to 'hand'`

Number

English Keywords	Svenska Keywords	Examples
sum	summa	`sum revenue`
average	genomsnitt	`average revenue by store`
count	antal	`count visitors by site`
max	max	`max sales by visitor by site`
min	min	`min revenue by store by campaign for cost > 5000`
standard deviation	standardavvikelse	`standard deviation revenue by product by month for date after`
unique count	antal unika	`unique count visitor by product page last week`
variance	varians	`variance sale amount by visitor by product for last year`

Comparative

English Keywords	Svenska Keywords	Examples
all	allt	`all`
between... and	mellan... och	`revenue between 0 and 1000`
vs, versus	mot, mot	`revenue east vs west`
>	>	`sum sale amount by visitor by product for last year sale amount > 2000`
<	<	`unique count visitor by product by store for sale amount < 20`
>=	>=	`count calls by employee lastname >= m`
<=	<=	`count shipments by city latitude <= 0`
=	=	`unique count visitor by store purchased products = 3 for last 5 days`
!=	!=	`sum sale amount region != canada region != mexico`

Location

English Keywords	Svenska Keywords	Examples
near	nära	`revenue store name county near san francisco`
near... within n miles\|km\|meters	nära... inom n miles\|km\|meter	`revenue store name county near alameda within 50 miles`
farther than n miles\|km\|meters from	längre än inom miles n miles\|km\|meter från	`average hours worked branch farther than 80 km from scarborough`

Period

English Keywords	Svenska Keywords	Examples
quarter (date)	kvartal (date)	`quarter (purchase date)`
quarter of year (date)	kvartal i år (date)	`quarter of year (purchase date)`
month of quarter (date)	månad i kvartal (date)	`month of quarter (purchase date)`
week of year (date)	vecka i år (date)	`week of year (ship date)`
week of quarter (date)	vecka i kvartal (date)	`week of quarter (ship date)`
week of month (date)	vecka i månad (date)	`week of month (ship date)`
day of year (date)	dag i år (date)	`day of year (ship date)`
day of quarter (date)	dag i kvartal (date)	`day of quarter (ship date)`
day (date)	dag (date)	`day (ship date)`
day of month (date)	dag i månad (date)	`day of month (order date)`
day of week (date)	veckodag (date)	`day of week (order date)`
hour (datetime)	timme (datetime)	`hour (timestamp)`

Was this page helpful?Give us feedback!

ThoughtSpot is the Modern Analytics Cloud company. Our Live Analytics services deliver personalized, actionable insights at the point of impact for every user, at every level.

Product

By Role

By Department

Solutions

About Us

Connect

(800) 508-7008