Use keywords to help define a search.

Note: 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.

< Back to English Keywords page

General

English Keywords	Suomi Keywords	Examples
top	ylös	top sales rep by count sales for average revenue > 10000 sales rep average revenue for each region top
bottom	alas	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	lajittele mukaan	revenue by state sort by average revenue revenue by customer sort by region

Date

English Keywords	Suomi Keywords	Examples
after	jälkeen	order date after 10/31/2014
before	ennen	order date before 03/01/2014
between … and ...	välillä … ja …	order date between 01/30/2012 and 01/30/2014
daily year-over-year	päivittäin vuosivertailu	growth of revenue by order date daily year-over-year
daily	päivittäin	shipments by region daily
day	päivä	count monday restaurant
day of week	viikonpäivä	revenue by day of week last 6 months
day of week	viikonpäivä	count shipments Monday
n days for each month	n päivää kullekin kuukausi	sales last 2 days for each month
n days for each quarter	n päivää kullekin vuosineljännes	revenue last 15 days for each quarter
n days for each week	n päivää kullekin viikko	total sold last 2 days for each week
n days for each year	n päivää kullekin vuosi	revenue last 300 days for each year
growth of … by … daily	kasvu … mukaan … päivittäin	growth of sales by order date daily
growth of … by … monthly	kasvu … mukaan … kuukausittain	growth of sales by date shipped monthly sales > 24000
growth of … by … quarterly	kasvu … mukaan … vuosineljännes	growth of sales by date shipped quarterly
growth of … by … weekly	kasvu … mukaan … viikoittain	growth of sales by receipt date weekly for pro-ski2000
growth of … by … yearly	kasvu … mukaan … vuosittain	growth of sales by date closed yearly
growth of … by ...	kasvu … mukaan …	growth of sales by order date
n hours for each day	n tuntia kullekin päivä	sales last 2 hours for each day
last day by	viimeinen päivä mukaan	customers last day by referrer
hourly	tunneittain	visitors by page name hourly
last month by	viimeinen kuukausi mukaan	customers last month by day
last n days	viimeinen n päivää	visitors last 7 days
last n quarters	viimeinen n vuosineljännestä	visitors last 2 quarters by month by campaign
last n weeks	viimeinen n viikkoa	visitors last 10 weeks by day
last quarter	viimeinen vuosineljännes	customers last quarter sale >300
last week	viimeinen viikko	customers last week by store
last year	viimeinen vuosi	top 10 customers last year by sale by store for region west
last n years	viimeinen n uotta	visitors last 5 years by revenue for sum revenue >5000
month to date	kuukausi päivämäärään	sales by product month to date sales > 2400
month year	kuukausi vuosi	commission by sales rep February 2014
month	kuukausi	commission January
month	kuukausi	revenue by month last year
monthly year-over-year	kuukausittain vuosivertailu	growth of revenue by receipt date monthly year-over-year
monthly	kuukausittain	commission > 10000 monthly
n months for each quarter	n kuukautta kullekin vuosineljännes	cost last 2 months for each quarter
n months for each year	n kuukautta kullekin vuosi	last 8 months for each year
n days ago	n päivää sitten	sales 2 days ago
n months ago	n kuukautta sitten	sales 2 months ago by region
n months	n kuukautta	visitors last 6 months for homepage visits > 30 by month
n quarters ago	n vuosineljännestä sitten	sales 4 quarters ago by product name contains deluxe
n weeks ago	n viikkoa sitten	sales 4 weeks ago by store
n years ago	n vuotta sitten	sales 5 years ago by store for region west
n years	n vuotta	opportunities next 5 years by revenue
next day	seuraava päivä	shipments next day by order
next month	seuraava kuukausi	appointments next month by day
next n days	seuraava n päivää	shipments next 7 days
next n months	seuraava n kuukautta	openings next 6 months location
next n quarters	seuraava n vuosineljännestä	opportunities next 2 quarters by campaign
next n weeks	seuraava n viikkoa	shipments next 10 weeks by day
next quarter	seuraava vuosineljännes	opportunities next quarter amount > 30000
next week	seuraava viikko	shipments next week by store
next year	seuraava vuosi	opportunities next year by sales rep
quarter to date	vuosineljännes päivämäärään	sales by product quarter to date for top 10 products by sales
quarterly year-over-year	vuosineljännes vuosivertailu	growth of revenue by date shipped quarterly year-over-year
quarterly	vuosineljännes	sales quarterly for each product
n quarters for each year	n vuosineljännestä kullekin vuosi	last 2 quarters for each year
today	tänään	sales today by store
week to date	viikko päivämäärään	sales by order date week to date for pro-ski200
week	viikko	revenue by week last quarter
weekly year-over-year	viikoittain vuosivertailu	growth of revenue by date shipped weekly year-over-year
weekly	viikoittain	revenue weekly
n weeks for each month	n viikkoa kullekin kuukausi	sales last 3 weeks for each month
n weeks for each quarter	n viikkoa kullekin vuosineljännes	last 2 weeks for each quarter
n weeks for each year	n viikkoa kullekin vuosi	last 3 weeks for each year
year to date	vuosi päivämäärään	sales by product year to date
year	vuosi	revenue by product 2014 product name contains snowboard
yearly	vuosittain	shipments by product yearly
yesterday	eilen	sales yesterday for pro-ski200 by store

Time

English Keywords	Suomi Keywords	Examples
detailed	eritelty	ship time detailed
last minute	viimeinen minuutti	count homepage views last minute
last hour	viimeinen tunti	count unique visits last hour
n minutes	n minuuttia	count visitors last 30 minutes
n hours	n tuntia	count visitors last 12 hours
n minutes ago	n minuuttia sitten	sum inventory by product 10 minutes ago
n hours ago	n tuntia sitten	sum inventory by product by store 2 hours ago

Text

English Keywords	Suomi Keywords	Examples
begins with	alkaa merkeillä	product name begins with 'pro'
contains	sisältää	product name contains "alpine" description contains "snow shoe"
ends with	päättyy merkkeihin	product name ends with 'deluxe'
not begins with	ei ala merkeillä	product name not begins with "tom's"
not contains	ei sisällä	product color not contains 'tan' product color not contains 'red'
not ends with	ei pääty merkkeihin	product name not ends with "trial"
similar to	samankaltainen kuin	course name similar to 'hand'
not similar to	erilainen kuin	course name not similar to 'hand'

Number

English Keywords	Suomi Keywords	Examples
sum	summa	sum revenue
average	keskiarvo	average revenue by store
count	määrä	count visitors by site
max	maks.	max sales by visitor by site
min	min.	min revenue by store by campaign for cost > 5000
standard deviation	keskihajonta	standard deviation revenue by product by month for date after
unique count	yksilöllinen määrä	unique count visitor by product page last week
variance	vaihtelu	variance sale amount by visitor by product for last year

Comparative

English Keywords	Suomi Keywords	Examples
all	kaikki	all
between... and	välillä … ja	revenue between 0 and 1000
vs, versus	vs, versus	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	Suomi Keywords	Examples
near	lähellä	revenue store name county near san francisco
near... within n miles|km|meters	lähellä alueen sisällä n mailia|km|metriä	revenue store name county near alameda within 50 miles
farther than n miles|km|meters from	kauempana kuin alueen sisällä n mailia|km|metriä	average hours worked branch farther than 80 km from scarborough

Period

English Keywords	Suomi Keywords	Examples
quarter (date)	vuosineljännes (date)	quarter (purchase date)
quarter of year (date)	vuosineljännes (date)	quarter of year (purchase date)
month of quarter (date)	vuosineljänneksen kuukausi (date)	month of quarter (purchase date)
week of year (date)	viikon nro (date)	week of year (ship date)
week of quarter (date)	vuosineljänneksen viikko (date)	week of quarter (ship date)
week of month (date)	kuukauden viikko (date)	week of month (ship date)
day of year (date)	vuoden päivä (date)	day of year (ship date)
day of quarter (date)	vuosineljänneksen päivä (date)	day of quarter (ship date)
day (date)	päivä (date)	day (ship date)
day of month (date)	kuukauden päivä (date)	day of month (order date)
day of week (date)	viikonpäivä (date)	day of week (order date)
hour (datetime)	tunti (datetime)	hour (timestamp)