Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



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>

...

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.

Requirements

...

  • WMS version 5.04 or higher
  • Licenses ?

...

  • - premium?

How to access

To access x-bees statistics, click on the Statistics button on left-hand part of the screen:  

...

  1. Search field that allows to look for necessary data. Refer to Start a new search sections of this guide for more details. 
  2. Watchlist with personalized set of metrics you choose to monitor
  3. List of saved answers and liveboards, which you created or whichwhich were shared with you or with a group company you belong to
  4. Trending Liveboards
  5. Trending Answers

...

On the window that pops up, choose the necessary Liveboard (1), select the metrics you want to add (2) from this liveboard, click Add metrics (3): 


Note

Note:  ____ what is the metrics limit? _____


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.

...

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 (inbound, outbound, trunk2trunk,------)
  • domain 
  • duration
  • email 
  • flags
  • hangup (caller, callee)
  • name
  • role
  • serial
  • service status ( - use this example
  • status (answered, unanswered)
  • subject
  • tags
  • talk time
  • time 
  • total duration
  • type (call, conference)
  • 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: 

...

  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, click on the necessary items to select them and press + Add Columns:


    Note

    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:

E.g. abt 5 ready-to use search queries ?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:

SOME USE CASES? 



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:

...

Note

Notes:

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

    Note


...

For example, for better visualization, let's slice the chart with color, for different services to be displayed with different colors on the chart. For this, we drag and from the service box under Slice with color option (1) and the chart changes its view to the following:

Note

Note: For detailed information about charts, refer to the Chart types section of this guide.


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

...

3. Choose an existing liveboard or create a new one

4. Click Pin:

...

...



Answers

Answers are An answer is the saved results result of a search. On the Answers tab, you can see the answers you saved, as well as answers of other users, in case they shared them with you or a group company you belong to.



If you tick the checkbox next to an answer, the following buttons appear above the answers list:

...

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

Liveboards act like dashboards. They are collections of related charts and tables, that you monitor most often. On the Liveboards tab, you can see the liveboards you saved, as well as liveboards of other users, in case they shared them with you or a group company you belong to:

View a Liveboard

...

  • Clicking on the Star icon next to Liveboard name, you can add it to favorites. 
  • Lock icon indicates whether you have view only or edit access to the Liveboard.
  • Schedule button allows to  If you want to share to configure reports to be sent to email(s) at specified interval
  • If you want to share the Liveboard with a user or group, click Share icon. 
  • Clicking More (three dots) button (1), you get access to the following options (2):
    • Make a copy
    • Add filters
    • Configure filters
    • Copy link
    • Present 
    • Manage schedules
    • Export TML 
    • Update Update from TML (edit access required)
    • Edit TML (edit access required)
    • Liveboard info


...


Add visualizations

In case you’ve created a Liveboard, but there are not answers yet, click Add visualizations:

...

The answer opens and besides viewing its details. Also, using the Explore this data panel on the right, you can modify the answer by applying additional filters, adding/ replacing columns, choose data for comparison:

Explore data - answer is not saved?

Edit answer - answer is not saved automatically - should pin?


Keyword reference

Keywords help to define a search.

  • Keywords - other languages - not all are present
  • which version


General

Note

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.

Example:

caller callee direction status duration today top 5

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 caller by conversations this month

bottom n





Generates the bottom n items from a sorted result.

Example:

bottom 10 caller by conversations this month

sort by





Sorts the result set by an attribute or measure.

Example:

caller callee direction status duration today sort by duration

by <measure>





Treats the measure as an attribute and groups the result set by it.

Example:

conversations by day

Date

KeywordExamples
after

conversations after 10/31/2022

before

conversations before 03/01/2022

between ... and ...

conversations between 01/30/2022 and 01/30/2022

day

conversations monday

day of week

conversations by day of week last 3 months

growth of …​ by ...

growth of conversations by time last month unanswered

growth of …​ by …​ daily

growth of conversations by time daily last month unanswered

growth of …​ by …​ monthly

growth of conversations by time monthly unanswered

growth of …​ by …​ quarterly

growth of conversations by time quarterly unanswered

growth of …​ by …​ weekly

growth of conversations by time weekly last month unanswered

last day by

conversations last day by callee

last month

conversations last month by callee

last month by

conversations last month by day

last n days

conversations last 7 days

last n months

conversations last 10 months by day

last n quarters

conversations last 2 quarters by month by service

last n weeks

conversations last 10 weeks by day

last quarter

conversations last quarter 

last week

conversations last week by service

last year

conversations last year by callee

month

conversations by month last year

month

conversations January

month to date

conversations month to date ??  

month year

conversations by service February 2022

n days ago

conversations 2 days ago

last n days for each month

conversations 2 days for each month

last n days for each quarter

conversations last 15 days for each quarter

last n days for each week

conversations last 2 days for each week

last n days for each year

conversations last 300 days for each year

last n hours for each day

conversations last 2 hours for each day

n months

conversations last 6 months

n months ago

conversations 2 months ago by service

last n months for each quarter

conversations last 2 months for each quarter

last n months for each year

conversations last 8 months for each year

n quarters ago

conversations 4 quarters ago by service

n weeks ago

conversations 4 weeks ago by callee

last n weeks for each month

conversations last 3 weeks for each month

last n weeks for each quarter

last 2 weeks for each quarter

quarter to date

sales by product quarter to date

for top 10 products by sales

this day

conversations this day by callee

this month

conversations this month by day
this quarterconversations this quarter by callee
this weekconversations this week by service
this yearconversations this year by callee
todayconversations today by callee
weekconversations by week last quarter
week to datesales by order date week to date for pro-ski200
yearrevenue by product 2014 product name contains snowboard

year to date

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

...

Comparative

KeywordExamples
all

conversations uk_support vs all

Note

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

conversations uk_support vs everything

Note

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)

caller callee direction status duration today callee !={null}

vs, versus

conversations uk_support vs us_support

...

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

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.

Chart types -remove

Column charts

The column chart is one of simplest, yet most versatile chart types. The column chart is often the chosen default chart type, and displays data as vertical columns. Column charts are vertical bar charts that display your data using rectangular bars. The length of the bar is proportional to the data value.

Your search must have at least one attribute and one measure to be represented as a column chart.

Stacked columns

The stacked column chart is similar to the column chart, but with one major difference. It includes a legend, which divides each column into additional sections, by color.

Note

Note: You can only use an attribute to slice with color.

Bar charts

The bar chart is very similar to the column chart. The only difference is that it is oriented horizontally, instead of vertically. The length of the bar is proportional to the data value.

Your search needs at least one attribute and one measure to be represented as a bar chart.

Stacked bar charts

Just like stacked columns, stacked bars combine the different secondary dimensions into a single stacked bar.

The stacked bar chart is similar to the bar chart, but it also includes a legend, which divides each bar into additional sections by color. 

Note

Note: You can only use an attribute to slice with color.

Line charts

Line charts are good at showing trends over intervals of time. Like the column chart, the line chart is one of the simplest, yet most versatile. It is often chosen as default visual representation. Line charts display your data as a series of data points connected by straight line segments. The system orders the measurement points by the x-axis value.

Your search must have at least one attribute and one measure to be represented as a line chart. If your search has multiple attributes, you can slice with color to sort by the second attribute.

Pie charts

The pie chart is a classic chart type that displays your search in a circle. 

Pie charts divide your data into sectors that each represent a proportion of a whole circle. To display the exact values of each slice and the percentage values, select the Edit chart configuration icon > Settings > All labels.

Your search needs at least one attribute and one measure to be represented as a pie chart. Also, there must be fewer than 250 values in the attribute column.

Pie in pie charts

The pie in pie chart can be created from a regular pie chart in order to compare more than one component of an attribute. Pie in pie charts show two concentric pie charts comparing different measures.

To see a pie in pie chart, assign two different measures to the Size section under Edit chart configuration.

Scatter charts

The scatter chart is useful for finding correlations or outliers in your data. Scatter charts display your data as a collection of points, which can either be evenly or unevenly distributed. Each point is plotted based on its own axes values. This helps you determine if there is a relationship between your searched columns.

Your search needs at least one attribute and one measure to be represented as a scatter chart.

Bubble charts

The bubble chart is a variation of the scatter chart, and its data points appear as bubbles. Your search must have at least one attribute and two measures to generate a bubble chart. The bubble chart displays three to five dimensions or measures of data. In addition to the traditional X and Y axis, the size of the bubble represents a measurement. Bubble charts can show two more attributes, when you slice and/or slice by color.

Pareto charts

The pareto chart is a type of chart that contains both columns and a special type of line chart.

The individual values of a pareto chart are represented in descending order by columns, and the cumulative percent total is represented by the line. The y-axis on the left is paired with the columns, while the y-axis on the right is paired with the line. By the end of the line, the cumulative percent total reaches 100 percent.

Your search needs at least one attribute and one measure to be represented as a pareto chart.

Waterfall charts

The waterfall chart shows how an initial value is affected by a series of intermediate positive or negative values. Waterfall charts are good for visualizing positive and negative growth, and therefore work well with the growth over time keyword. The columns are color-coded to distinguish between positive and negative values. Your search needs at least one attribute and one measure to be represented as a waterfall chart.

Treemap charts

The treemap chart displays hierarchical data as a set of nested rectangles.

Treemap charts use color and rectangle size to represent two measure values. Each rectangle, or branch, is a value of the attribute. Some branches can contain smaller rectangles, or sub-branches. This setup makes it possible to display a large number of items in an efficient way. You can rearrange the columns of your search into category, color, and size under Edit chart configuration.

Your search needs at least one attribute and two measures to be represented as a treemap chart.

Heatmap charts

The heatmap chart displays individual data values in a matrix following a color scale. The value of each cell depends on the measure you choose under Edit chart configuration.

Line column charts

The line column chart combines the column and line charts. Your search needs at least one attribute and two measures to be represented as a line column chart.

Line column charts display one measure as a column chart, and the other as a line chart. Each of these measures has its own y-axis.

Stacked line column charts

This chart is similar to the line column chart, except that it divides its columns with an attribute in the legend. The line stacked column chart combines stacked column and line charts. There are two y-axes, one for each measure.

Funnel chart

The funnel chart shows a process with progressively decreasing proportions amounting to 100 percent in total. You can visualize the progression of data as it passes from one phase to another. Data in each of these phases is represented as different proportions.

Your search needs at least one attribute and one measure to be represented as a funnel chart. The attribute must contain 50 or fewer values.

Pivot table

Pivot tables are charts that enable you to explore an alternate visualization of your data in a wide, customizable table. With pivot tables, you can use the same table to visualize some of your data horizontally, and some data vertically. You can restructure your pivot table by dragging and dropping the measures and attributes under Edit chart configuration, or by dragging and dropping column headings on the table itself.

Sankey charts

The Sankey chart type contains both columns and a special type of line chart. Sankey diagrams illustrate a flow through, a process, or a system. When you build a Sankey chart, you must provide at least 2 (two) attributes and one measure. Your x-axis attributes can contain at most 13 values; any more and you cannot view a SanKey chart. 

Radar charts

The Radar (or spiderweb) chart contains both columns and a special type of line chart. It displays data in the form of a two-dimensional chart of three or more qualities, represented on axes that radiate from the same point.

...

.