Together, the examples make up one dashboard. They all start in the designer; how to open it is described in Designing dashboards.
Creating and saving a dashboard
- In the Administration, click Add under Dashboard. The designer opens an empty dashboard with the data source “myContactCenter”. In the Agent, choose Home › File › New.
- Home › Dashboard › Title: enter a name under Text:, for example “Sales calls”, and click OK.
- Insert items as in the following examples.
- Save with Save in the Quick Access Toolbar or under Home › File — also after every further change.
Conversations per day
- Home › Insert › Chart.
- In the data source browser, choose the Query
ConversationTrackingStatistics. - Drag
ConversationStartTimeonto Argument. - Menu of “ConversationStartTime (Year)” › Day-Month-Year. With Day alone, the chart combines the days 1 to 31 of all months.
- Drag
guidonto Value: “guid (Count)” is the number of conversations. Menu › Rename… › New name: “Conversations” › OK. - Calls only: Data › Edit Filter with the condition
ConversationTypeequalsInboundCall. - One color per skill: drag
SkillNameonto Series. - Design › Series Type selects, for example, lines or areas instead of bars.
The days begin at midnight UTC — see Date filter.
A grid per agent
- Home › Insert › Grid; Query
AgentTrackingDetails. - Drag
AgentNameonto New Column. - Drag
isConnectedConversationonto New Column — the sum is the number of connections — and rename the column to “Connected” with Rename…. If the column shows individual values instead of a sum, set Column type: to Measure using the icon of the column › Column Options. - Drag
WrapupDurationonto New Column and name it “Wrap-up (s)”. Menu › Format…: Unit: Ones, Precision: 0 › OK. - Total row: right-click the column header “Connected” › Add Total › Sum; likewise for “Wrap-up (s)”.
- Only the ten agents with the most connections: menu of “AgentName” › Top N… › Enabled, Mode: Top, Count: 10, Measure: “Connected” › OK.
- Design › Column Width Mode › AutoFit to Contents.
Choosing the period
- Home › Insert › Filter Elements › Date Filter; Query
ConversationTrackingStatistics. - Drag
ConversationStartTimeonto Dimension; in the menu, choose Day-Month-Year if another interval is set. - Design › Filter Type › Between.
- Design › Edit Periods: add “Today”, “Last 7 Days” and “This Month” with a double-click, select Default for “Last 7 Days” and click Close.
- The grid per agent reads another query. For it, create a second date filter
with
StartTimefromAgentTrackingDetails.
Filtering by skill
- Home › Insert › Filter Elements › Combo Box; Query
ConversationTrackingStatistics. - Drag
SkillNameonto Dimension. - Design › Item Type › Checked, so that several skills can be selected; also Enable Search.
- So that the grid per agent follows as well: Data › Cross-Data-Source Filtering.
- An item that should always show all skills: select it › Data › Ignore Master Filters.
Shares of the conversation types
- Home › Insert › Pies; Query
ConversationTrackingStatistics. - Drag
ConversationTypeonto Argument andguidonto Value. - Design › Data Labels › Argument And Percent; Data Labels Position › Outside.
- If you like, Design › Donut.
- As a filter for the other items: Data › Multiple Master Filter. A click on a segment filters; Clear Master Filter in the header of the pie cancels it.
The segments are named like the conversation types in the statistics, for
example InboundCall. Readable names come from a
calculated field that you use instead of
ConversationType.
A measure as a card
- Home › Insert › Cards; Query
ConversationTrackingStatistics. - Drag
IsConnectedonto Actual — the sum is the number of connected conversations — andguidonto Target, the number of all conversations. - Icon at the Cards section › Card Settings: under Layout Options, Select template: Compact; under Delta Options, Value type: Percent of target and Result indication: Greater is good › OK.
The card shows the share of connected conversations in the selected period.
Long wait times in red
- Home › Insert › Grid; Query
ConversationTrackingStatistics. DragSkillNameandTotalWaitDurationonto New Column. - Menu of “TotalWaitDuration (Sum)” › Average.
- Menu › Add Format Rule › Value › Greater Than.
- Enter 20 — the seconds —, choose Pale Red under Appearance and, if required, Apply to row › OK.
To change or remove the rule: Home › Item › Edit Rules.
Talk time in minutes
- Data Source tab; in the data source browser, choose the Query
ConversationTrackingStatistics. - Add Calculated Field › enter
[TotalConnectDuration] / 60in the Expression Editor window › OK. - Right-click the new field › Rename to “Talk minutes”; Field Type › Double.
- Drag “Talk minutes” into an item like any other field, with Sum or Average.
Passing it on as a PDF
- Export To in the title bar › Export To PDF.
- Size: A4, Page Layout: Landscape; under Include:, select Filters so that the selected filters also appear on the page.
- Export and choose where to save the file.
You pass on the dashboard itself to another installation in the Administration with Home › File › Export; there you load it with Open and save it.