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> |
Table of Contents |
---|
Introduction
x-bees statistics Analytics 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 Analytics tool can perfectly address whatever need you may have.
Requirements
- WMS version 5.04 or higher
- License: xb-Premium
How to access
To access x-bees statisticsAnalytics, click on the StatisticsAnalytics button on left-hand part of the screen:
Here, you can find 4 tabs:
- x-bees StatisticsHome: the list of saved and trending Liveboards and Answers, metrics watchlist
- x-bees StatisticsSearch: 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 StatisticsAnswers: the list of saved Answers (the results of your search)
- x-bees StatisticsLiveboards: a collection of answers in a pinboard (dashboards) that you use most often in your analytics purposes
Home
On the Home tab, you can see:
- Search field that allows to look for necessary data. Refer to Start a new search sections of this guide for more details.
- Watchlist with personalized set of metrics you choose to monitor
- List of saved answers and liveboards, which you created or which were shared with you or with a company you belong to
- Trending Liveboards
- Trending Answers
Navigate the list of Answers and Liveboards
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
Share Answers and Liveboards
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:
Add metrics to watchlist
To always have metrics you constantly monitor within an easy reach on Home tab, click Add metrics to your watchlist:
...
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):
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.
Data items (columns)
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
...
You can also choose values by which you want to filter data: tick off necessary values and click Apply and the selected values appear in the search field.
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, 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:
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:
...
Note |
---|
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. |
View query details
To view details of the query, click on the Query details button (info icon) on the right:
Change display of an answer
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:
...
Note | ||
---|---|---|
Notes:
|
Edit chart configuration
If you are not fully satisfied with how the chart looks like, you can easily modify it:
...
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.
...
- 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 StatisticsAnswers tab.
Pin an answer
- To add an answer to Liveboards tab, which contains a collection of answers in a pinboard (dashboards) view, click Pin:
...
3. Choose an existing liveboard or create a new one
4. Click Pin:
Answers
An answer is the saved 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 company you belong to.
...
Clicking on an answer, it opens in a table/ chart view with the same editing options described in the x-bees Statistics Search 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 company you belong to:
View a Liveboard
Click on the necessary Liveboard from the list to see its details:
...
Note |
---|
Note: Currently, to update data on a Liveboard, page needs to be refreshed. |
Manage Liveboards
You can arrange items on your Liveboard to your liking just by dragging and dropping them.
...
- 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 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, enter name or email address of user or group you want to share the Liveboard with, select access right and click Share:
- 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 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:
...
A Search field appears and you can start exploring the data you need. The same functionality described in the x-bees Statistics Search 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
To view details of an answer on a liveboard, hover your mouse over the desired answer and click Explore:
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:
Keyword reference
Keywords help to define a search.
General
Note |
---|
Note: When using the top or bottom keywords without specifying a number (n), the number defaults to |
...
Keyword - English | IT | DE | FR | ES | Description |
---|---|---|---|---|---|
top n | superiore n | beste n | haut n | primeros 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 | beste n per | 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 | inferiore n | schlechteste n | bas n | últimos n | Generates the bottom n items from a sorted result. Example: bottom 10 caller by conversations this month |
sort by | ordina per | sortieren nach | trier par | ordenar por | 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
Keyword | IT | DE | FR | ES | Examples |
---|---|---|---|---|---|
after | dopo | nach dem | après | después de | conversations after 10/31/2022 |
before | primo | vor dem | avant | antes de | conversations before 03/01/2022 |
between ... and ... | tra … e … | zwischen dem … und dem … | entre … et … | entre … y … | conversations between 01/30/2022 and 01/30/2022 |
day | giorno | Tag | jour | día | conversations monday |
day of week | giorno della settimana | Tag der Woche | jour de la semaine | día de la semana | conversations by day of week last 3 months |
growth of … by ... | crescita di … su base … | wachstum von … pro… | croissance de … par … | crecimiento de … hasta … | growth of conversations by time last month unanswered |
growth of … by … daily | crescita di … su base … giornaliero | wachstum von … pro… täglich | croissance de … par … tous les jours | crecimiento de … hasta … a diario | growth of conversations by time daily last month unanswered |
growth of … by … monthly | crescita di … su base … mensile | wachstum von … pro … monatlich | croissance de … par … tous les mois | crecimiento de … hasta … mensual | growth of conversations by time monthly unanswered |
growth of … by … quarterly | crescita di … su base … trimestrale | wachstum von … pro … vierteljährlich | croissance de … par … tous les trimestres | crecimiento de … hasta … trimestral | growth of conversations by time quarterly unanswered |
growth of … by … weekly | crescita di … su base … settimanale | wachstum von … pro … wöchentlich | croissance de … par … toutes les semaines | crecimiento de … hasta … semanal | growth of conversations by time weekly last month unanswered |
last day by | ultimo giorno su base | am letzten Tag pro | dernier jour par | último día hasta | conversations last day by callee |
last month | conversations last month by callee | ||||
last month by | ultimo mese su base | im letzten Monat pro | dernier mois par | último mes hasta | conversations last month by day |
last n days | ultimo n giorni | letzte n Tage | dernier n jours | últimos n días | conversations last 7 days |
last n months | conversations last 10 months by day | ||||
last n quarters | ultimo n trimestri | letzte n Quartale | dernier n trimestres | últimos n trimestres | conversations last 2 quarters by month by service |
last n weeks | ultimo n settimane | letzte n Wochen | dernier n semaines | últimas n semanas | conversations last 10 weeks by day |
last quarter | ultimo trimestre | letzte Quartal | dernier trimestre | último trimestre | conversations last quarter |
last week | ultimo settimana | letzte Woche | dernier semaine | última semana | conversations last week by service |
last year | ultimo anno | letzte Jahr | dernier année | último año | conversations last year by callee |
month | mese | Monat | mois | mes | conversations by month last year conversations January |
month to date | mese finora | Monat bis jetzt | mois à ce jour | mes hasta la fecha | conversations month to date ?? |
month year | mese anno | Monat Jahr | mois année | mes año | conversations by service February 2022 |
n days ago | n giorni fa | vor n Tagen | n jours il y a | n días hace | conversations 2 days ago |
last n days for each month | n giorni per ogni mese | n Tage in jeder Monat | n jours pour chaque mois | n días para cada mes | conversations 2 days for each month |
last n days for each quarter | n giorni per ogni trimestre | n Tage in jeder Quartal | n jours pour chaque trimestre | n días para cada trimestre | conversations last 15 days for each quarter |
last n days for each week | n giorni per ogni settimana | n Tage in jeder Woche | n jours pour chaque semaine | n días para cada semana | conversations last 2 days for each week |
last n days for each year | n giorni per ogni anno | n Tage in jeder Jahr | n jours pour chaque année | n días para cada año | conversations last 300 days for each year |
last n hours for each day | n ore per ogni giorno | n Stunden in jeder Tag | n heures pour chaque jour | n días para cada año | conversations last 2 hours for each day |
n months | n mesi | n Monaten | n mois | n meses | conversations last 6 months |
n months ago | n mesi fa | vor n Monaten | n mois il y a | n meses hace | conversations 2 months ago by service |
last n months for each quarter | n mesi per ogni trimestre | n Monate in jeder Quartal | n mois pour chaque trimestre | n meses para cada trimestre | conversations last 2 months for each quarter |
last n months for each year | n mesi per ogni anno | n Monate in jeder Jahr | n mois pour chaque année | n meses para cada año | conversations last 8 months for each year |
n quarters ago | n trimestri fa | vor n Quartalen | n trimestres il y a | n trimestres hace | conversations 4 quarters ago by service |
n weeks ago | n settimane fa | vor n Wochen | n semaines il y a | n semanas hace | conversations 4 weeks ago by callee |
last n weeks for each month | n settimane per ogni mese | n Wochen in jeder Monat | n semaines pour chaque mois | n semanas para cada mes | conversations last 3 weeks for each month |
last n weeks for each quarter | n settimane per ogni trimestre | n Wochen in jeder Quartal | n semaines pour chaque trimestre | n semanas para cada trimestre | last 2 weeks for each quarter |
quarter to date | trimestre finora | Quartal bis jetzt | trimestre ce jour | trimestre hasta la fecha | 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 quarter | conversations this quarter by callee | ||||
this week | conversations this week by service | ||||
this year | conversations this year by callee | ||||
today | oggi | heute | aujourd’hui | hoy | conversations today by callee |
week | settimana | Woche | semaine | semana | conversations by week last quarter |
week to date | settimana finora | Woche bis jetzt | semaine à ce jour | semana hasta la fecha | sales by order date week to date for pro-ski200 |
year | anno | Jahr | année | año | revenue by product 2014 product name contains snowboard |
year to date | anno finora | Jahr bis jetzt | année à ce jour | año hasta la fecha | sales by product year to date |
yesterday | ieri | gestern | hier | ayer | sales yesterday for pro-ski200 by store |
Time
Keyword | IT | DE | FR | ES | Examples |
---|---|---|---|---|---|
detailed | dettagliato | détaillée | detallado | conversation time detailed | |
last hour | ultimo ora | dernier heure | último hora | count unique conversations last hour | |
last minute | ultimo minuto | dernier minute | último minuto | count conversations last minute | |
n hours | n ore | n heures | n horas | count conversations [ last ] 12 hours | |
n hours ago | n ore fa | n heures il y a | n horas hace | conversations 2 hours ago | |
n minutes | n minuti | n minutes | n minutos | count conversations [ last ] 30 minutes | |
n minutes ago | n minuti fa | n minutes il y a | n minutos hace | sum conversations by service 10 minutes ago | |
this hour | conversations this hour | ||||
this minute | conversations this minute |
Text
Keyword | IT | DE | FR | ES | Examples |
---|---|---|---|---|---|
begins with | inizia con | commence par | empieza por | conversations name begins with 'joe' by name // returns the list of conversations that have name starting with 'Joe' | |
contains | contiene | contient | contiene | conversations name contains 'bill' by name | |
ends with | finisce con | se termine pas | termina por | conversations name ends with 'joe' | |
similar to | simile a | similaire à | similar a | conversations name similar to 'joseph' | |
not begins with | non inizia con | ne commence pas par | no empieza por | conversations name not begins with 'bill' | |
not contains | non contiene | ne contient pas | no contiene | conversations name not contains 'joe' | |
not ends with | non finisce con | ne termine pas par | no termina por | conversations name not ends with 'joe' | |
not similar to | diverso da | pas similaire à | no es similar a | conversations name not similar to 'hand' |
...
Note |
---|
Notes:
For example, if you search for If you search for |
Number
Keyword | IT | DE | FR | ES | Examples |
---|---|---|---|---|---|
average | media | Durchschnitt | moyenne | promedio | conversations average duration by service this month |
count | conteggio | Anzahl | nombre | recuento | count service unique count caller by service |
max | max | Maximum | max | máx | max talk time conversations by service |
min | min | Minimum | min | mín | min answer time by service |
standard deviation | deviazione | Standardabweichung | écart type | desviación estándar | standard deviation revenue by product by month for date after 10/31/2010 |
sum | somma | Summe | somme | suma | sum revenue |
unique count | conteggio univoco | eindeutige Anzahl | nombre unique | recuento único | unique count conversation id |
variance | varianza | Varianz | variance | varianza | variance duration by service |
Comparative
Keyword | IT | DE | FR | ES | Examples | ||
---|---|---|---|---|---|---|---|
all | tutto | alle | tout | todo/a | conversations uk_support vs all
| ||
between... and... | tra … e | zwischen … und | entre … et | entre … y | revenue between 0 and 1000 | ||
= (equal) | = | = | = | = | unique count visitor by store purchased products = 3 for last 5 days | ||
everything | tutto | alles | tout | todo/a | conversations uk_support 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) | != | != | != | != | caller callee direction status duration today callee !={null} | ||
vs, versus | risp. a, rispetto a | vs, versus | vs, versus | vs, contra | conversations uk_support vs us_support |
...
For example: customer name = {empty} or service != {null}.
Period
Keyword | IT | DE | FR | ES | Examples |
---|---|---|---|---|---|
day | giorno (date) | Tag (date) | jour (date) | día (date) | conversations by day |
day of month | giorno del mese (date) | Tag des Monats (date) | jour du mois (date) | día del mes (date) | conversations day of month by month |
day of quarter | giorno del trimestre (date) | Tag des Quartals (date) | jour du trimestre (date) | día del trimestre (date) | conversations day of quarter by year |
day of week | giorno della settimana (date) | Tag der Woche (date) | jour de semaine (date) | día de la semana (date) | conversations by week day of week |
day of year | giorno dell’anno (date) | Tag des Jahres (date) | jour de l’année (date) | día del año (date) | conversations day of year by year |
hour | ora (datetime) | Stunde (datetime) | heure (datetime) | hora (datetime) | conversations by hour weekly |
month of quarter | mese del trimestre (date) | Monat des Quartals (date) | mois du trimestre (date) | mes del trimestre (date) | conversations month of quarter by year |
quarter | trimestre (date) | Quartal (date) | trimestre (date) | trimestre (date) | conversations by quarter |
quarter of year | trimestre dell’anno (date) | Quartal des Jahres (date) | trimestre de l’année (date) | trimestre del año (date) | conversations quarter of year |
week of month | settimana del mese (date) | Woche des Monats (date) | semaine du mois (date) | semana del mes (date) | conversations week of month |
week of quarter | settimana del trimestre (date) | Woche des Quartals (date) | semaine du trimestre (date) | semana del trimestre (date) | conversations week of quarter |
week of year | settimana dell’anno (date) | Woche des Jahres (date) | semaine de l’année (date) | semana del año (date) | conversations week of year |
In / Not in
Keyword | IT | DE | FR | ES | 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 |
...