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