Overview

The KPI widget has a DataTable option that allows advanced aggregation and display of data from any source that returns JSON and then format the output of certain fields within that JSON as a table. To use this feature add a KPI widget to a page and in the configuration of a cell select Data table in the Type dropdown:

There are three main fields to complete:

1. the source url e.g. for ES endpoint on the live server,

Request a Link through Eigen if not already configured

Example link - http://ef.eigen.co/plugins/servlet/epm//ei-applet/search?cmd=DODIRECTSEARCH&clientname=elasticsearch-test&index=alertstate


2. the source parameters i.e. the GET params you would append to the url. There is one of these per line with the the parameter name and value being separated by a | (pipe)

search|{"query":{"query_string":{"query":"status.global:red AND type:equipment"}}}


3. the fields from the returned JSON you want to display in table columns. There is one of these per line with the column name and field being separated by a | (pipe). The field is defined using a JSONPath expression (http://goessner.net/articles/JsonPath/)

Tag|$.results[*].tag
System|$.results[*].system

How to Configure a KPI Data Table

The KPI allows you to use different data sources to drive the information shown to a user.  This example shows how to use an SQL data source