| Table of Contents |
|---|
...
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.
...
The Select Datablock sub-setting will display.
4. Select Date Picker Drillthrough from the datablock options.
...
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.
...
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.
...
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.
...
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:
 |
...
Link
Link allows you to link the drillthrough to another drillthrough. There must be a common column between two datablocks.
...
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.
 |  |
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:
...
| Note |
|---|
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.
...