Use keywords to help define a search.

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)