Drillthrough (Datablocks)

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.

Open

The Add Content setting will display.

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

Open

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.

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.

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.

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.

Drillthrough Functionalities

Columns Sort

Click the column header to sort its column cells.

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.

Column Filtering

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

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
}
}

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: