{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"3cf54eb2-3db5-4fda-bf21-c62f95aa361e"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"18673848-3620-4e1b-82f8-c374c751504b"}},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Overview / Description","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Drillthrough ","type":"text","marks":[{"type":"strong"}]},{"text":"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. ","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Common Use Case","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Drillthrough datablock is commonly used to investigate and analyze raw index records. ","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisites","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Note that Drillthrough will also work with Real-time message groups, as well as Transaction-based eMite reports","type":"text"}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Add Drillthrough to a Page","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"1. Select the ","type":"text"},{"text":"page ","type":"text","marks":[{"type":"strong"}]},{"text":"where you want to add a datablock. In this example, Training Demo page is selected. ","type":"text"}]},{"type":"paragraph","content":[{"text":"2. From Edit Page menu, select ","type":"text"},{"text":"Add Content","type":"text","marks":[{"type":"strong"}]},{"text":". ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":1365,"id":"7f4144f8-bb99-41e6-a37e-b89127453084","collection":"contentId-1858176728","type":"file","height":767}}]},{"type":"paragraph","content":[{"text":"The Add Content setting will display.","type":"text"}]},{"type":"paragraph","content":[{"text":"3. Input the ","type":"text"},{"text":"number of datablocks","type":"text","marks":[{"type":"strong"}]},{"text":" you want to add to the page, then click ","type":"text"},{"text":"Add","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":630,"id":"f8691d22-cf5e-42b1-8f45-7c4a75ae0765","collection":"contentId-1858176728","type":"file","height":216}}]},{"type":"paragraph","content":[{"text":"The Select Datablock sub-setting will display.","type":"text"}]},{"type":"paragraph","content":[{"text":"4. Select ","type":"text"},{"text":"Drillthrough ","type":"text","marks":[{"type":"strong"}]},{"text":"from the datablock options.","type":"text"}]},{"type":"paragraph","content":[{"text":"5. Update the ","type":"text"},{"text":"Datablock Title","type":"text","marks":[{"type":"strong"}]},{"text":" and ","type":"text"},{"text":"Datablock Style","type":"text","marks":[{"type":"strong"}]},{"text":" accordingly.","type":"text"}]},{"type":"paragraph","content":[{"text":"6. Click ","type":"text"},{"text":"Add","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":700,"id":"aa0f0e11-d3dd-4d5a-ab43-16e89c5f24d9","collection":"contentId-1858176728","type":"file","height":485}}]},{"type":"paragraph","content":[{"text":"The added datablock will display on the page. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":1365,"id":"44f0f81a-6537-449a-bf51-9213bdb19200","collection":"contentId-1858176728","type":"file","height":767}}]},{"type":"paragraph","content":[{"text":"7. Under ","type":"text"},{"text":"Edit Page","type":"text","marks":[{"type":"strong"}]},{"text":" menu, select ","type":"text"},{"text":"Save Page","type":"text","marks":[{"type":"strong"}]},{"text":" to save the datablock in the page.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":1365,"id":"ec20269a-4ca9-4935-b454-18126817ed7e","collection":"contentId-1858176728","type":"file","height":767}}]},{"type":"paragraph","content":[{"text":"Once the changes have been saved, a ","type":"text"},{"text":"success message","type":"text","marks":[{"type":"strong"}]},{"text":" will display on the top right corner of the screen.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":298,"id":"79cbc7b4-cd44-493a-8171-1d116112e41f","collection":"contentId-1858176728","type":"file","height":75}}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Link Another Datablock to Drillthrough","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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. ","type":"text"}]},{"type":"paragraph","content":[{"text":"1. On the ","type":"text"},{"text":"datablock header of the datablock you want to link","type":"text","marks":[{"type":"strong"}]},{"text":" to the drillthrough, click the ","type":"text"},{"text":"Link ","type":"text","marks":[{"type":"strong"}]},{"text":"icon. In this example, Cube Report demo - %Answered by Queue datablock will be linked to the drillthrough. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":961,"id":"a88b3fd3-a109-4056-ac77-e6fda9ee52c7","collection":"contentId-1858176728","type":"file","height":320}}]},{"type":"paragraph","content":[{"text":"The Link Targets window will display.","type":"text"}]},{"type":"paragraph","content":[{"text":"2. Select the ","type":"text"},{"text":"drillthrough ","type":"text","marks":[{"type":"strong"}]},{"text":"to where you want to link the datablock. ","type":"text"}]},{"type":"paragraph","content":[{"text":"3. Click ","type":"text"},{"text":"Link","type":"text","marks":[{"type":"strong"}]},{"text":". ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":600,"id":"bdd14e56-b303-4b06-9aba-bf22802fbf68","collection":"contentId-1858176728","type":"file","height":559}}]},{"type":"paragraph","content":[{"text":"The cube report datablock is now linked to/interactive with the drillthrough. ","type":"text"}]},{"type":"paragraph","content":[{"text":"To check if the link is working, ","type":"text"}]},{"type":"paragraph","content":[{"text":"4. On the cube report, click on a ","type":"text"},{"text":"dimension ","type":"text","marks":[{"type":"strong"}]},{"text":"which details/raw data you want to display on the drillthrough. In this example, eMite dimension is clicked. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The drillthrough will be populated according to the selected dimension in the datablock. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":1365,"id":"0e5715b6-d171-4c23-bacc-f53879ed40f8","collection":"contentId-1858176728","type":"file","height":767}}]},{"type":"paragraph","content":[{"text":"5. Under ","type":"text"},{"text":"Edit Page","type":"text","marks":[{"type":"strong"}]},{"text":" menu, select ","type":"text"},{"text":"Save Page","type":"text","marks":[{"type":"strong"}]},{"text":" to save the datablock in the page. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The selected dimension on the datablock is displayed on the drillthrough’s header.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":574,"id":"4170485d-73e2-4b01-884e-46ac9a3ad869","collection":"contentId-1858176728","type":"file","height":24}}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Drillthrough UI Controls","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Show/Hide Columns","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Show/Hide Columns allows you to select the columns you only want displayed on your view. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the lock icon in the right column to lock a grid column and put it always on the left. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Drag the column from left side to right to reorder the columns. ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"dbe17560-32f9-4f79-96e5-6d0db9c99092","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":540,"id":"b0741ce7-a182-48b3-b5a3-1ee091091cbf","collection":"contentId-1858176728","type":"file","height":722}}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Export to Excel","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Export to Excel exports and saves the current drillthrough content to your local drive in Excel format (.xlsx). ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"d4adc964-9b94-4a3d-9af6-df52f5e4c513","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Export to CSV","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Export to CSV exports and saves the current drillthrough content to your local drive in CSV format (.csv). ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"a6fbe823-938b-46ca-ade4-c49adff7750e","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Export to Xml Column","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Export to CSV exports and saves the current drillthrough content to your local drive in XML format (.xml). ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"47b4a7fc-e034-41a6-b467-717e73a27fb7","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Grid Rule","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Grid Rule allows you to update grid settings. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"3601603b-cf7a-40a9-ae4f-bae9f63ebf15","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"table","attrs":{"layout":"default","localId":"e8564e55-0cd2-4685-9b05-3e82544aff4a"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[680.0]},"content":[{"type":"paragraph","content":[{"text":"Settings","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Clock Counter","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" - ","type":"text","marks":[{"type":"em"}]},{"text":"Clock counter is useful to show presence time for an agent and max wait time for an agent group in a call center system. ","type":"text"}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"To remove clock counter, select the date column, then click Remove Counter. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":676,"id":"a7768852-bfed-4437-aeeb-50f339708e91","collection":"contentId-1858176728","type":"file","height":321}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[680.0]},"content":[{"type":"paragraph","content":[{"text":"Grid Rule","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":676,"id":"6ded2ed2-3621-46a7-98a6-2916ca5c7523","collection":"contentId-1858176728","type":"file","height":481}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[680.0]},"content":[{"type":"paragraph","content":[{"text":"Column Setting","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":676,"id":"0a62540e-990f-48fd-bdce-852035cf4d9c","collection":"contentId-1858176728","type":"file","height":679}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[680.0]},"content":[{"type":"paragraph","content":[{"text":"Grouping Aggregation","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Select a group by column, an aggregation column, then the type of aggregation. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":676,"id":"7b9b404b-3f13-4afc-959b-731fce339b03","collection":"contentId-1858176728","type":"file","height":333}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[680.0]},"content":[{"type":"paragraph","content":[{"text":"Row Template","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":676,"id":"7aa0b835-849e-4fbe-b489-d3b75d903eb4","collection":"contentId-1858176728","type":"file","height":352}}]}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Hyper-linking","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"For example, suppose you have a product sales portal at ","type":"text"},{"text":"http://yoursalesportal/","type":"text","marks":[{"type":"link","attrs":{"href":"http://yourservicedesk/"}}]},{"text":" and you wish to navigate to it when you click on one of the product code in the drillthough.","type":"text"}]},{"type":"paragraph","content":[{"text":"1. On the drillthrough header, click on the ","type":"text"},{"text":"Grid Rule ","type":"text","marks":[{"type":"strong"}]},{"text":"icon. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":238,"id":"b94e59e5-6457-4139-8d5b-087a81d48977","collection":"contentId-1858176728","type":"file","height":116}}]},{"type":"paragraph","content":[{"text":"2. Select the ","type":"text"},{"text":"column ","type":"text","marks":[{"type":"strong"}]},{"text":"you wish to link. ","type":"text"}]},{"type":"paragraph","content":[{"text":"3. Type the ","type":"text"},{"text":"URL ","type":"text","marks":[{"type":"strong"}]},{"text":"that you would like to pass your link to. ","type":"text"}]},{"type":"paragraph","content":[{"text":"4. Click ","type":"text"},{"text":"Add Link","type":"text","marks":[{"type":"strong"}]},{"text":". ","type":"text"}]},{"type":"paragraph","content":[{"text":"Note that the linked column IDs change color to represent links. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":25.0},"content":[{"type":"media","attrs":{"width":625,"id":"c042134a-6a1e-4284-89f3-eb90174db4ca","collection":"contentId-1858176728","type":"file","height":302}}]},{"type":"paragraph","content":[{"text":"The field value is then passed into the hyperlinked URL. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":1337,"id":"69d58692-e8af-488b-a5dc-2348c0cd44d7","collection":"contentId-1858176728","type":"file","height":396}}]},{"type":"paragraph","content":[{"text":"If you make an error you can remove the link from the column. ","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Transpose 5 Rows","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Transpose 5 Rows exchanges the places of the drillthrough column and row. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"47c774ac-4258-423e-8ea1-f5fe2f03048e","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"table","attrs":{"layout":"default","localId":"2d51e9e4-5f92-4028-b155-c88478b79e8e"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"ed76ee47-9d23-4ae4-953a-c4b81abf9730","collection":"contentId-1858176728","type":"file","height":385}},{"type":"caption","content":[{"text":"Before transpose","type":"text"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"8acce6a0-9fbd-4858-8646-63be8e4f1168","collection":"contentId-1858176728","type":"file","height":385}},{"type":"caption","content":[{"text":"After transpose","type":"text"}]}]}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Indexsearch Setting","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Indexsearch Setting allows you to perform fixed complex drillthrough queries via the Elasticsearch DSL Query String Query. Click ","type":"text"},{"text":"here","type":"text","marks":[{"type":"link","attrs":{"href":"https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html"}}]},{"text":" for details about the Elasticsearch query syntax.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"531d68cc-8ab6-435e-b173-b10a985cea01","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"table","attrs":{"layout":"default","localId":"0d3576b8-c460-4b53-bb59-41bca6cce030"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[680.0]},"content":[{"type":"paragraph","content":[{"text":"Query","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"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. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":540,"id":"cec38c17-b2a5-4dc2-9299-ee2af5ea7c62","collection":"contentId-1858176728","type":"file","height":318}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[680.0]},"content":[{"type":"paragraph","content":[{"text":"Realtime","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"eMite Messaging Web Service","type":"text","marks":[{"type":"link","attrs":{"href":"https://wiki.emite.com/wiki/MessagingWebService"}}]},{"text":". ","type":"text"}]},{"type":"paragraph","content":[{"text":"The drillthrough datablock can now be configured to display real-time messages apart from the ElasticSearch query. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Message Group ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"- ","type":"text","marks":[{"type":"em"}]},{"text":"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. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Filter ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"-","type":"text","marks":[{"type":"em"}]},{"text":" 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. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The format is columnname:columnvalue. Examples: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To see message from a group, the filter string will be “Group:groupname1”. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To see message for interaction calls, the filter string will be “Status:Interaction”. ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":540,"id":"dbb6e2bf-b300-42db-a56c-16c269e03049","collection":"contentId-1858176728","type":"file","height":325}}]}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Link","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Link allows you to link the drillthrough to another drillthrough. There must be a common column between two datablocks. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":323,"id":"0f0c9841-acf0-42e6-9bc5-526596a7b3d6","collection":"contentId-1858176728","type":"file","height":26}}]},{"type":"paragraph","content":[{"text":"In this example, “inbound” cell is clicked. The linked drillthrough will be populated according to the selected cell in the source drillthrough.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":540,"id":"185d4c48-54e3-439c-bccc-591d5f6c9b96","collection":"contentId-1858176728","type":"file","height":503}}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":1365,"id":"730a7b8d-940f-4bc9-9065-801daca41f07","collection":"contentId-1858176728","type":"file","height":767}}]},{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"To learn more about the other cube report UI controls, go to ","type":"text"},{"text":"UI Controls","type":"text","marks":[{"type":"link","attrs":{"href":"https://prophecyinternational.atlassian.net/l/c/SDpFq3Vv"}}]},{"text":". ","type":"text"}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Drillthrough Functionalities","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Columns Sort","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Click the column header to sort its column cells. ","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"223c3f21-a715-4ad8-8547-1c7ba886592e"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"eec1bbb1-cd0f-4fa8-bf5a-67dea3be47c2","collection":"contentId-1858176728","type":"file","height":384}},{"type":"caption","content":[{"text":"Before - Click on column header","type":"text"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"49d48228-08e2-4b27-8740-8b8498afd2a4","collection":"contentId-1858176728","type":"file","height":384}},{"type":"caption","content":[{"text":"After - Click on column header","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"Multiple Columns Sort","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Drillthrough columns can be sorted by multiple columns. It will do a sort by, then by logic if multiple columns are selected for sorting. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":339,"id":"0f4543d6-6095-4571-9b10-9861c4394140","collection":"contentId-1858176728","type":"file","height":124}}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Columns Reorder","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Columns can be dragged from right to left, or vice versa, to reorder them. ","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"53746747-a077-4f41-b61d-1a970ffd1535"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"752b4d68-8cc1-467b-866d-b0097a62518f","collection":"contentId-1858176728","type":"file","height":384}},{"type":"caption","content":[{"text":"Before - Drag and drop Key ID","type":"text"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"8febe305-9b8f-4e94-86f1-90932ede3818","collection":"contentId-1858176728","type":"file","height":384}},{"type":"caption","content":[{"text":"After - Drag and drop Key ID","type":"text"}]}]}]}]}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Column Filtering","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Drillthrough supports many Column filtering options based on the column data type. ","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"760637ba-15d8-442f-a97b-717bfb058f9c"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"c8429e4f-551c-4d46-8997-e64000361f64","collection":"contentId-1858176728","type":"file","height":384}},{"type":"caption","content":[{"text":"Numeric columns - Filter options","type":"text"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":750,"id":"19cd95bb-caac-4fdf-9a02-3b521340ef48","collection":"contentId-1858176728","type":"file","height":384}},{"type":"caption","content":[{"text":"Text columns - Filter options","type":"text"}]}]}]}]}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Cell Popup","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"For cells that are partly displayed, click on a cell to pop up and display its full content. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":750,"id":"d094daec-ec97-4a84-bd2c-002f5cc369e9","collection":"contentId-1858176728","type":"file","height":384}}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Maximum Rows","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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: ","type":"text"}]},{"type":"paragraph","content":[{"text":"PUT ","type":"text"},{"text":"http://localhost:9200/yourinexname/_settings/","type":"text","marks":[{"type":"link","attrs":{"href":"http://localhost:9200/yourinexname/_settings/"}}]}]},{"type":"paragraph","content":[{"text":"{","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"\"index\": {","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"\"max_result_window\": 500000","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"}","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"}","type":"text","marks":[{"type":"code"}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Exporting a large number of rows can impact dashboard performance.","type":"text"}]}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Batch Messages","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Current Real Time Datasources","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Pure Cloud RealTime Adapter","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://wiki.emite.com/wiki/AdaptersV5/PureCloudRealTime"}}]},{"text":" - Generates real time messages for","type":"text"},{"text":"Agent Presence","type":"text","marks":[{"type":"em"}]},{"text":"and","type":"text"},{"text":"Queue Status","type":"text","marks":[{"type":"em"}]},{"text":"by listening to events pushed from Pure Cloud.","type":"text"}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Row Template","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"The template is implemented as a kendo template. The user needs to follow its specification to create a row template. ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://docs.telerik.com/kendo-ui/framework/templates/overview"}},{"text":" ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Use ","type":"text"},{"text":"#:columnname#","type":"text","marks":[{"type":"code"}]},{"text":" to specify a column value in that row. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use ","type":"text"},{"text":"onclick=\"grid_template_prev_page(this)","type":"text","marks":[{"type":"code"}]},{"text":" to call a function when clicking on some html elements in that row.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use ","type":"text"},{"text":"##","type":"text","marks":[{"type":"code"}]},{"text":" to escape # for color, etc. ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Row template example:","type":"text"}]},{"type":"codeBlock","content":[{"text":"

#:Agent_Group#

\n>

#: Agent_Name#

#: Agent_Current_Presence #

#: Last_Update#

\n #: AcdSkills#\n

\n>

\n>","type":"text"}]}],"version":1}