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