Html |
---|
<div id="fb-root"></div> <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = 'https://connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.11'; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));</script> |
...
Info |
---|
On this page, you can find documentation about x-bees Snalytics which provides all the information you need to keep on top of your business. Created: May 2022 Permalink: https://confluence.wildix.com/x/BYL6Bg |
Html |
---|
<div class="fb-like" data-href="#" data-layout="button_count" data-action="recommend" data-size="large" data-show-faces="true" data-share="true"></div> |
...
Click on the necessary liveboard from the list to see its details:
Keyword reference
Use keywords to help define a search.
General
Note |
---|
Note: When using the top or bottom keywords without specifying a number (n), the number defaults to |
Add visualizations
In case you’ve created a Liveboard, but there are not answers yet, click Add visualizations:
A Search field appears and you can start exploring the data you need. The same functionality described in the x-bees Statistics section of this guide is available on Liveboards tab.
Also, you can add visualizations to a liveboard by clicking Pin when you view an answer on the Search/ Answers/ Home tab:
Explore answers on Liveboard
Keyword reference
Use keywords to help define a search.
General
Note |
---|
Note: When using the top or bottom keywords without specifying a number (n), the number defaults to |
Keyword | Description |
---|---|
top n | Generates the top n items from a sorted result. Examples: top top 10 sales rep revenue top sales rep by count sales for average revenue > 10000 sales rep average revenue for each region top |
top n measure1 by attribute|measure2 | Calculates top n items, then sorts the top items by another measure or attribute. Contrast with top n (swaps the order of operations). Example: top 10 sales rep revenue by profit margin |
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 |
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 |
by <measure> | Treats the measure as an attribute and groups the result set by it. Examples: conversations by day |
Date
Keyword | Examples |
---|---|
after | order date conversations after 10/31/20142022 |
before | order date conversations before 03/01/20142022 |
between ... and ... | order date conversations between 01/30/2012 2022 and 01/30/20142022 |
daily | shipments by region conversations daily |
daily year-over-year | growth of revenue by order date daily year-over-year |
day | count monday restaurant |
day of week | revenue conversations by day of week last 6 months |
growth of … by ... | growth of sales by order date |
growth of … by … daily | growth of sales by order date daily |
growth of … by … monthly | growth of sales by date shipped monthly sales > 24000 |
growth of … by … quarterly | growth of sales by date shipped quarterly |
growth of … by … weekly | growth of sales by receipt date weekly for pro-ski2000 |
hourly | visitors conversations by page name callee hourly |
last day by | customers conversations last day by referrercallee |
last month | customers conversations last month by storecallee |
last month by | customers conversations last month by day |
last n days | visitors conversations last 7 days |
last n months | visitors conversations last 10 months by day |
last n quarters | visitors conversations last 2 quarters by month by campaignservice |
last n weeks | visitors conversations last 10 weeks by day |
last n years | visitors conversations last 5 2 years by revenue for sum revenue > 5000service |
last quartercustomers last quarter sale > 300 | conversations last quarter |
last week | customers conversations last week by storeservice |
last year | top 10 customers conversations last year by sale by store for region westcallee |
month | revenue conversations by month last year |
month | commission conversations January |
month to date | sales by product month to date sales > 2400 |
month year | commission conversations by sales rep service February 20142022 |
monthly | commission > 10000 conversations by service monthly |
monthly year-over-year | growth of revenue by receipt date monthly year-over-year |
n days ago | sales conversations 2 days ago |
last n days for each month | sales last conversations 2 days for each month |
last n days for each quarter | revenue conversations last 15 days for each quarter |
last n days for each week | total sold conversations last 2 days for each week |
last n days for each year | revenue conversations last 300 days for each year |
last n hours for each day | sales conversations last 2 hours for each day |
n months | visitors conversations last 6 months for homepage visits > 30 by month |
n months ago | sales conversations 2 months ago by regionservice |
last n months for each quarter | cost conversations last 2 months for each quarter |
last n months for each year | conversations last 8 months for each year |
n quarters ago | sales conversations 4 quarters ago by product name contains deluxeservice |
last n quarters for each year | last 2 quarters for each year |
n weeks ago | sales conversations 4 weeks ago by storecallee |
last n weeks for each month | sales conversations last 3 weeks for each month |
last n weeks for each quarter | last 2 weeks for each quarter |
last n weeks for each year | last 3 weeks for each year |
n years | opportunities next 5 years by revenue |
n years ago | sales 5 conversations 2 years ago by store for region westservice |
next day | shipments next day by order |
next month | appointments next month by day |
next n days | shipments next 7 days |
next n months | openings next 6 months location |
next n quarters | opportunities next 2 quarters by campaign |
next n weeks | shipments next 10 weeks by day |
next n years | projected deals next 5 years |
next quarter | opportunities next quarter amount > 30000 |
next week | shipments next week by store |
next year | opportunities next year by sales rep |
quarter to date | sales by product quarter to date for top 10 products by sales |
quarterly sales quarterly for each product | conversations quarterly by service |
quarterly year-over-year | growth of revenue by date shipped quarterly year-over-year |
this day | shipments conversations this day by ordercallee |
this month | appointments conversations this month by day |
this quarter | opportunities conversations this quarter amount > 30000by callee |
this week | shipments conversations this week by storeservice |
this year | opportunities conversations this year by sales repcallee |
today | sales conversations today by storecallee |
week | revenue conversations by week last quarter |
week to date | sales by order date week to date for pro-ski200 |
weekly | revenue conversations weekly |
weekly year-over-year | growth of revenue by date shipped weekly year-over-year |
year | revenue by product 2014 product name contains snowboard |
year to date | sales by product year to date |
yearly | shipments by product yearly |
yesterday | sales yesterday for pro-ski200 by store |
Time
Keyword | Examples |
---|---|
detailed | ship time detailed |
last hour | count unique visits last hour |
last minute | count homepage views last minute |
n hours | count visitors [ last | next ] 12 hours |
n hours ago | sum inventory by product by store 2 hours ago |
n minutes | count visitors [ last | next ] 30 minutes |
n minutes ago | sum inventory by product 10 minutes ago |
next hour | count projected visitors next hour |
next minute | count projected visitors next minute |
this hour | count visitors this hour |
this minute | count visitors this minute |
...
Comparative
Keyword | Examples | ||
---|---|---|---|
all | revenue asia vs all
| ||
between... and... | revenue between 0 and 1000 | ||
= (equal) | unique count visitor by store purchased products = 3 for last 5 days | ||
everything | revenue asia vs everything
| ||
> (greater than) | sum sale amount by visitor by product for last year sale amount > 2000 | ||
>= (greater than or equal) | count calls by employee lastname >= m | ||
< (less than) | unique count visitor by product by store for sale amount < 20 | ||
<= (less than or equal) | count shipments by city latitude <= 0 | ||
!= (not equal) | sum sale amount region != canada date != last 5 days | ||
vs, versus | revenue east vs west |
...
In / Not in
Keyword | Description |
---|---|
in | Query in query search (intersection of two sets). Must match last attribute before keyword with first attribute inside subsearch. 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 |
not in | Relative complement of two sets. Must match last attribute before keyword with first attribute inside subsearch. Syntax: attribute not in (attribute subsearch) Example: product name 2014 product name not in (product name 2013) sales |
Note |
---|
Note: Searches with the in keyword do not include {null} values. To include {null} values, create a formula for the relevant attribute in your search, to convert {null} values to 'unknown,' or some similar word. |
...