Drillthrough (Datablocks)

Owned by Arielle Kaye Odeste
Last updated: Jan 19, 2022Version comment
9 min read

Overview / Description

Drillthrough datablock is used to display raw index records from a target index. It can either be used as a standalone datablock, or as a destination for a link from a Status datablock to show the relevant data behind the value for a selected measure.

Common Use Case

Drillthrough datablock is commonly used to investigate and analyze raw index records.

Prerequisites

  • Note that Drillthrough will also work with Real-time message groups, as well as Transaction-based eMite reports

Add Drillthrough to a Page

1. Select the page where you want to add a datablock. In this example, Training Demo page is selected.

2. From Edit Page menu, select Add Content.

The Add Content setting will display.

3. Input the number of datablocks you want to add to the page, then click Add.

The Select Datablock sub-setting will display.

4. Select Drillthrough from the datablock options.

5. Update the Datablock Title and Datablock Style accordingly.

6. Click Add.

The added datablock will display on the page.

7. Under Edit Page menu, select Save Page to save the datablock in the page.

Once the changes have been saved, a success message will display on the top right corner of the screen.

Link Another Datablock to Drillthrough

An existing datablock can be linked to a drillthrough to display the details/raw data of a specific measure in the datablock. In order to link drillthrough to another datablock, there has to be a common column between the two datablcoks.

1. On the datablock header of the datablock you want to link to the drillthrough, click the Link icon. In this example, Cube Report demo - %Answered by Queue datablock will be linked to the drillthrough.

The Link Targets window will display.

2. Select the drillthrough to where you want to link the datablock.

3. Click Link.

The cube report datablock is now linked to/interactive with the drillthrough.

To check if the link is working,

4. On the cube report, click on a dimension which details/raw data you want to display on the drillthrough. In this example, eMite dimension is clicked.

The drillthrough will be populated according to the selected dimension in the datablock.

5. Under Edit Page menu, select Save Page to save the datablock in the page.

The selected dimension on the datablock is displayed on the drillthrough’s header.

Drillthrough UI Controls

Show/Hide Columns

Show/Hide Columns allows you to select the columns you only want displayed on your view.

  • Click the lock icon in the right column to lock a grid column and put it always on the left.

  • Drag the column from left side to right to reorder the columns.

Export to Excel

Export to Excel exports and saves the current drillthrough content to your local drive in Excel format (.xlsx).

Export to CSV

Export to CSV exports and saves the current drillthrough content to your local drive in CSV format (.csv).

Export to Xml Column

Export to CSV exports and saves the current drillthrough content to your local drive in XML format (.xml).

Grid Rule

Grid Rule allows you to update grid settings.

Settings

Clock Counter - Clock counter is useful to show presence time for an agent and max wait time for an agent group in a call center system.

When a date column is a start date for some action, and you want to track how long has it been last since the start date, you can add that column as a clock counter. A timer will run and update the duration time(in HH:mm:ss format) every second in the grid.

To remove clock counter, select the date column, then click Remove Counter.

Grid Rule

Column Setting

Grouping Aggregation

Select a group by column, an aggregation column, then the type of aggregation.

Row Template

Hyper-linking

Hyper-linking is the ability to assign a hyperlink to a column in the drillthrough. This can be useful to connect eMite results to systems outside of eMite.

For example, suppose you have a product sales portal at http://yoursalesportal/ and you wish to navigate to it when you click on one of the product code in the drillthough.

1. On the drillthrough header, click on the Grid Rule icon.

2. Select the column you wish to link.

3. Type the URL that you would like to pass your link to.

4. Click Add Link.

Note that the linked column IDs change color to represent links.

The field value is then passed into the hyperlinked URL.

If you make an error you can remove the link from the column.

Transpose 5 Rows

Transpose 5 Rows exchanges the places of the drillthrough column and row.

Before transpose
After transpose

Indexsearch Setting

Indexsearch Setting allows you to perform fixed complex drillthrough queries via the Elasticsearch DSL Query String Query. Click here for details about the Elasticsearch query syntax.

Query

Select an indexgroup, cube, and time range, then a dimension for linking. Enter a query string to run the query. If the query is "*" or blank, the search return all records.

It will show raw query result in the drillthrough grid. The security slicer will also get applied in the backend which make the data secure to users.

Realtime

Real-time messages are data that by-pass the ElasticSearch onboarding and is onboarded directly into the dashboard using eMite Messaging Web Service. In brief, the eMite Messaging Web Service implements WebSockets via Signal R technology and allows real-time communications between the eMite Adapters and the dashboard. Click here to read more about the eMite Messaging Web Service.

The drillthrough datablock can now be configured to display real-time messages apart from the ElasticSearch query.

Message Group - A real-time message group is basically a set of logical data usually defined by the source component such as an adapter. The message group drowdown will be populated when page is loaded. The schema is coming from messaging web service's cache which is populated by the real-time adapters.

Filter - The filter input is used to filter down the message before the message is coming so that you can only see what you are interested in.

The format is columnname:columnvalue. Examples:

  • To see message from a group, the filter string will be “Group:groupname1”.

  • To see message for interaction calls, the filter string will be “Status:Interaction”.

Link

Link allows you to link the drillthrough to another drillthrough. There must be a common column between two datablocks.

In this example, “inbound” cell is clicked. The linked drillthrough will be populated according to the selected cell in the source drillthrough.

 

To learn more about the other cube report UI controls, go to UI Controls.

Drillthrough Functionalities

Columns Sort

Click the column header to sort its column cells.

Before - Click on column header
After - Click on column header

Multiple Columns Sort

Drillthrough columns can be sorted by multiple columns. It will do a sort by, then by logic if multiple columns are selected for sorting. 

Columns Reorder

Columns can be dragged from right to left, or vice versa, to reorder them.

Before - Drag and drop Key ID
After - Drag and drop Key ID

Column Filtering

Drillthrough supports many Column filtering options based on the column data type.

Numeric columns - Filter options
Text columns - Filter options

Cell Popup

For cells that are partly displayed, click on a cell to pop up and display its full content.

Maximum Rows

The default maximum rows to export in elastic search is 10000. So, you can only have 10000 rows in drillthrough by default. To export more than 10000 rows, update the elastic search setting like below:

PUT   http://localhost:9200/yourinexname/_settings/

{
"index": {
"max_result_window": 500000
}
}

Exporting a large number of rows can impact dashboard performance.

Batch Messages

When switching between pages, the real-time message in the page will be cleared first, then send a command to messaging web service to receive all the latest message and show them at once. A loading indicator will appear when it's loading.

Current Real Time Datasources

Pure Cloud RealTime Adapter - Generates real time messages forAgent PresenceandQueue Statusby listening to events pushed from Pure Cloud.

Row Template

Sometimes, the default grid row display is not enough for some customized layouts. Row template is created to support any kinds of layout by the dashboard user using the same drillthrough data.

The template is implemented as a kendo template. The user needs to follow its specification to create a row template. Templates Overview - Kendo UI Templates - Kendo UI for jQuery

  • Use #:columnname# to specify a column value in that row.

  • Use onclick="grid_template_prev_page(this) to call a function when clicking on some html elements in that row.

  • Use ## to escape # for color, etc.

Row template example:

<div style="display:inline-block;width:10%;overflow: hidden;"> <div>#:Agent_Group# </div> <div>&nbsp;</div> ><div style="display:inline-block;width:80%;overflow: hidden;"> <div> <div style="display:inline-block;width:40%"> #: Agent_Name# </div> <div style="display:inline-block;width:30%">#: Agent_Current_Presence #</div> <div style="display:inline-block;width:30%">#: Last_Update# </div> </div> <div style="text-overflow: ellipsis;"> #: AcdSkills# </div> > <div style="display:inline-block;color:##08AED6;width:10%"> <div><a onclick="grid_template_prev_page(this)"><i class="fa fa-chevron-up" aria-hidden="true"></i></a> </div> <div><a onclick="grid_template_next_page(this)"><i class="fa fa-chevron-down" aria-hidden="true"></i> </a></div> >