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
Introduction
x-bees statistics is an advanced yet easy-to-use analytics tool, which lets you monitor all the data you need to always stay on top of your business. With x-bees, you are not limited to a predefined set of data tables and charts. On the contrary, you set them up yourself choosing the data you are interested in and customizing tables and charts to your personal liking. This means x-bees statistics tool can perfectly address whatever need you may have.
How to access
To access x-bees statistics, click on the Statistics button on left-hand part of the screen:
Here, you can find 4 tabs:
- x-bees Statistics: the list of saved and trending Liveboards and Answers, metrics watchlist
- x-bees Statistics: allows to search for data, configure the view of charts and tables containing the search results, save them to Answers and Liveboards, etc.
- x-bees Statistics: the list of saved Answers (the results of your search)
- x-bees Statistics: a collection of answers in a pinboard (dashboards) that you use most often in your analytics purposes
Home
The tab displays the list of dashboards, saved searches and answers, which you created or which were shared with you. On the right, you can see the list of trending Liveboards and Answers.
To easily find the necessary data, you can:
- Switch between tabs All/ Answers / Liveboards
- Filter answers and liveboards by tags and authors
- Click on the star icon next to the necessary answer/ liveboard to add it to favorites
- Toggle the switch on next to My favorites option to have only favorite answers/ liveboards displayed
If you check the boxes in front of desired answers/ liveboards, the following options appear at the top: Mark as favorite/ Remove from favorites and Share:
To share reports with others, click Share -> enter name or email of a user or group -> add message if required -> press Share:
On the Home tab, you can also use Search field to look for necessary data. Refer to Start a new search section for more details.
Search
On the Search tab, you can type in the search bar what information you want to explore and x-bees returns the search results in the form of a table or chart.
Search is based on the tables that exist in your data. Tables are made of rows and columns, like spreadsheets. You can search by typing in:
- Name of data item (column): like callee, connect time, talk time
- Special keywords: like today, yesterday, >, or contains
Click on the Data button to the left of the search field to see the list of available data items:The list of data items (columns) includes the following options:
- average duration
- callee
- caller
- connect time
- conversation id
- conversations
- direction
- domain
- duration
- flags
- hangup
- name
- role
- serial
- service
- status
- subject
- tags
- talk time
- time
- total duration
- type
- wait time
Hovering a mouse over any of these items, you can see a tooltip with the following info: name, description, data source (if applicable), and data type.
Start a new search
Click Search on the top navigation bar:
Start typing your search request, using necessary data items and keywords.
Alternatively, you can double-click on the preferred data items on the left-side panel and they are automatically added to the Search field. To add multiple items, you can click on the necessary items to select them and press + Add Columns:Note: Typing in your search query, you may notice that search items are of different colours:
- blue = attributes: primarily text or date values. Usually, attributes make up the x-axis of your chart. Examples: caller name, call status, etc.
- green = measures: numeric values, e.g. duration of a call
- grey = filters, e.g. outbound, inbound
3. Once your search query is ready, press Enter on keyboard, or click Go to the right of the search bar:
Your search is given an automatic title based on your search columns, and is displayed as either a table or chart, depending on how it is best represented. You can change display of the search result to fit your needs.
Example:
If you type in the search request "caller callee direction status duration today", the system returns a table with total duration of calls including information about caller, callee, direction of calls (inbound/ outbound), and call status:
Edit a search
You can edit a search without affecting existing search results. When you click a search phrase, it is highlighted, and x-bees displays other suggestions from which you can choose to replace the highlighted phrase. When you hover over a boxed phrase, you can see an x, which you can click to remove it from the search. You can insert a new phrase in the middle of a search, by clicking between phrases and entering the new phrase. You can merge phrases without breaking the search.
If you find yourself looking at a table or chart, but it doesn’t seem to contain all the data you expect, try looking in the search bar for filters in gray boxes. If you remove filters, you get all available data for that search.
Change display of a search result
You can change the view of your answer so it appears as either a table or a chart. To change the view of your answer, toggle between either a table or a chart type: When you display your data as a chart, x-bees automatically selects the type of chart that works best for your data. If you want to use another type, click Change visualization (chart icon) on the right:Select the type of chart you want:
See detailed information about chart item
In the example on the screenshot above, we searched for unanswered incoming calls this month by service and chose the data to be displayed in a stacked column chart.
If, say, you need a more detailed information regarding any of the service/ group displayed in the chart, right-click on the necessary item on visualization (1) -> choose Drill down (2):In the Drill down pop-up screen, choose the data you want to explore:For example, if you select the option caller, x-bees returns the list of phone numbers, whose calls were missed by the chosen group, and how many calls were missed by each number:To return to the previous view of the chart, click back to the right of the search field:
Exclude or include data
You can include or exclude row values from your answer.
To exclude or include row values:
- Right-click the necessary item on visualization or table cell
- Click Exclude "value" or Only Include "value" if available
Save an answer
An answer is the result of a single search. You can save an answer you want to work more on later, or just keep it for your personal use.
Click on the More (three dots) button at the top and choose Save:
Enter name and description and click Save answer:
The saved answer is added to the x-bees Statistics tab.
Pin an answer
To add an answer to Liveboards tab, which contains a collection of answers in a pinboard (dashboards) view, click Pin:
Answers
The Answers tab allows to view and modify saved search results as individual answers. Here are displayed both your answers and answers shared with you by other users.
If you tick the checkbox next to an answer, the following buttons appear above the answers list:
- Share: allows to share the answer with other users or groups
- Delete (personal answers only): deletes the answer
- Apply Tag (personal answers only): allows to tag the answer
- Export TML: uploads the answer in .tml file
- Edit TML: opens TML editor
Clicking on an answer, it opens in a table/ chart view with the same editing options described in the x-bees Statistics section of this guide:
Liveboards
Click on the necessary Liveboard to see its details:
Keyword reference
Use keywords to help define a search.
General
Note: When using the top or bottom keywords without specifying a number (n), the number defaults to 10
.
Keyword | Description |
---|---|
top n | Generates the top n items from a sorted result. Examples: 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 after 10/31/2014 |
before | order date before 03/01/2014 |
between ... and ... | order date between 01/30/2012 and 01/30/2014 |
daily | shipments by region daily |
daily year-over-year | growth of revenue by order date daily year-over-year |
day | count monday restaurant |
day of week | revenue 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 by page name hourly |
last day by | customers last day by referrer |
last month | customers last month by store |
last month by | customers last month by day |
last n days | visitors last 7 days |
last n months | visitors last 10 months by day |
last n quarters | visitors last 2 quarters by month by campaign |
last n weeks | visitors last 10 weeks by day |
last n years | visitors last 5 years by revenue for sum revenue > 5000 |
last quarter | customers last quarter sale > 300 |
last week | customers last week by store |
last year | top 10 customers last year by sale by store for region west |
month | revenue by month last year |
month | commission January |
month to date | sales by product month to date sales > 2400 |
month year | commission by sales rep February 2014 |
monthly | commission > 10000 monthly |
monthly year-over-year | growth of revenue by receipt date monthly year-over-year |
n days ago | sales 2 days ago |
last n days for each month | sales last 2 days for each month |
last n days for each quarter | revenue last 15 days for each quarter |
last n days for each week | total sold last 2 days for each week |
last n days for each year | revenue last 300 days for each year |
last n hours for each day | sales last 2 hours for each day |
n months | visitors last 6 months for homepage visits > 30 by month |
n months ago | sales 2 months ago by region |
last n months for each quarter | cost last 2 months for each quarter |
last n months for each year | last 8 months for each year |
n quarters ago | sales 4 quarters ago by product name contains deluxe |
last n quarters for each year | last 2 quarters for each year |
n weeks ago | sales 4 weeks ago by store |
last n weeks for each month | sales 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 years ago by store for region west |
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 |
quarterly year-over-year | growth of revenue by date shipped quarterly year-over-year |
this day | shipments this day by order |
this month | appointments this month by day |
this quarter | opportunities this quarter amount > 30000 |
this week | shipments this week by store |
this year | opportunities this year by sales rep |
today | sales today by store |
week | revenue by week last quarter |
week to date | sales by order date week to date for pro-ski200 |
weekly | revenue 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 |
Text
Keyword | Examples |
---|---|
begins with | product name begins with 'pro' // returns all products that start with 'pro' product name begins with 'pro' product name begins with 'sport' // returns all products that start with 'pro' // OR 'sport' product name begins with 'pro' product color begins with 'bl' // returns all products that start with 'pro' // AND have color that starts with 'bl' (blue or black) |
contains | product name contains "alpine" description contains "snow shoe" |
ends with | product name ends with 'deluxe' |
similar to | course name similar to 'hand' |
not begins with | product name not begins with "tom's" |
not contains | product color not contains 'tan' product color not contains 'red' |
not ends with | product name not ends with "trial" |
not similar to | course name not similar to 'hand' |
Notes:
- When more than one
begins with
orends with
keyword in a search or formula on the same column is used, results are returned using anOR
condition. When you use a combination of
begins with
andends with
, results are returned using theAND
condition.When using multiple
begins with
on different columns, results are returned using theAND
condition.
For example, if you search for state name begins with "V" state name begins with "C"
, your results are: Virginia, Vermont, California, and Connecticut.
If you search for state name begins with V state name ends with T
, your only result is Vermont.
Number
Keyword | Examples |
---|---|
average | average revenue by store |
count | count visitors by site |
max | max sales by visitor by site |
min | min revenue by store by campaign for cost > 5000 |
standard deviation | standard deviation revenue by product by month for date after 10/31/2010 |
sum | sum revenue |
unique count | unique count conversation id |
variance | variance sale amount by visitor by product for last year |
Comparative
Keyword | Examples |
---|---|
all | revenue asia vs all Note: The all keyword can only be used as part of a versus phrase. |
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 Note: The everything keyword can only be used as part of a versus phrase. |
> (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 |
You can use special constants for null and empty values with the = and != keywords: {null} and {empty}.
For example: customer name = {empty} or department != {null}.
Location
Keyword | Examples |
---|---|
farther than n miles|km|meters from … | average hours worked branch farther than 80 km from scarborough |
near | revenue store name county near san francisco |
near … within n miles|km|meters | revenue store name county near alameda within 50 miles |
Period
Keyword | Examples |
---|---|
day | orders by day |
day of month | sales day of month by month |
day of quarter | deals day of quarter by year |
day of week | customers by week day of week |
day of year | ad clicks day of year by year |
hour | visitors by hour weekly |
month of quarter | purchases month of quarter by year |
quarter | purchases by quarter |
quarter of year | opportunities quarter of year last 4 years yearly |
week of month | product shipments week of month yearly |
week of quarter | revenue week of quarter |
week of year | new products week of year last 3 years yearly |
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: 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.