Skip to end of banner
Go to start of banner

x-bees Statistics

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

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. 

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
  • email 
  • 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 

  1. Click Search on the top navigation bar.

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

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. If, say, you want the same data to be displayed not for today only, but for last week, for example, click on the "today" filter in the search field and choose the preferred option:


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. Also, you can merge phrases without breaking the search. 

Note: In case a table or chart doesn’t seem to contain all the data you expect, try looking in the search bar for filters in gray boxes. Remove unnecessary filters, you get all available data for that search.


Change display of a search result 

Switch between table/ chart view

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: Your search needs at least one attribute and one measure to be presented as a chart. 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:You can choose from a large number of chart types, each providing a different visualization for your answer. Select the type of chart you want:

Notes:

  • Some chart types may not be available, depending on the columns in your search. Unavailable chart types are grayed out.
  • Hovering over a chart type icon tells you what columns you require before you can use it:


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:

  1. Right-click the necessary item on visualization or table cell
  2. 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.

  1. Click on the More (three dots) button at the top and choose Save:

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

Answers are the saved results of a search. On the Answers tab, you can see the answers you saved, as well as answers of other users, in case these people shared them with you or a group you belong to.



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

KeywordExamples
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
count shipments Monday

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 yearsopportunities next 5 years by revenue
n years agosales 5 years ago by store for region west
next dayshipments next day by order
next monthappointments next month by day
next n daysshipments next 7 days
next n monthsopenings next 6 months location
next n quartersopportunities next 2 quarters by campaign

next n weeks

shipments next 10 weeks by day
next n yearsprojected deals next 5 years
next quarteropportunities next quarter amount > 30000
next weekshipments next week by store
next yearopportunities 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 quarteropportunities this quarter amount > 30000
this weekshipments this week by store
this yearopportunities this year by sales rep
todaysales today by store
weekrevenue by week last quarter
week to datesales by order date week to date for pro-ski200
weeklyrevenue weekly
weekly year-over-year

growth of revenue by date shipped weekly year-over-year

yearrevenue by product 2014 product name contains snowboard

year to date

sales by product year to date
yearlyshipments by product yearly
yesterdaysales yesterday for pro-ski200 by store

Time

KeywordExamples
detailed

ship time detailed

last hourcount unique visits last hour
last minutecount homepage views last minute
n hourscount visitors [ last | next ] 12 hours
n hours ago

sum inventory by product by store 2 hours ago

n minutescount visitors [ last | next ] 30 minutes
n minutes agosum inventory by product 10 minutes ago

next hour

count projected visitors next hour
next minutecount projected visitors next minute
this hourcount visitors this hour
this minutecount visitors this minute


Text 

KeywordExamples
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 tocourse 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 withproduct name not ends with "trial"
not similar tocourse name not similar to 'hand'


Notes:

  • When more than one begins with or ends with keyword in a search or formula on the same column is used, results are returned using an OR condition.
  • When you use a combination of begins with and ends with, results are returned using the AND condition.

  • When using multiple begins with on different columns, results are returned using the AND 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

KeywordExamples
averageaverage revenue by store
count

count visitors by site

max

max sales by visitor by site

minmin 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 countunique count conversation id
variancevariance sale amount by visitor by product for last year

Comparative

KeywordExamples
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

KeywordExamples
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

KeywordExamples
day

orders by day

day of monthsales 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 yearad clicks day of year by year
hourvisitors by hour weekly
month of quarterpurchases 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 quarterrevenue week of quarter

week of year

new products week of year last 3 years yearly

In / Not in

KeywordDescription
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
(= Find sales for all products ordered in 2014 that were not ordered in 2013)

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.

  • No labels