This Kibana visualization plugin is like a Data Table, but with enhanced features like computed columns, filter bar and pivot table.
- Add computed columns, based on other columns :
- Support for expr-eval expressions
- Support for numeric columns (ex:
col0 + col1orcol[0] + col[1]) - Support for string columns, including HTML (ex:
col0 > 0 ? 'OK' : 'KO') - Support for date columns
- Ability to reference total hits count returned by ES query (ex:
col0 / total * 100) - Ability to reference a column by its label (ex:
col['Sum of duration'] / col['Count']) - Ability to reference a column total (ex:
col['Sales by month'] / total['Sales by month']) - Ability to define/reference arrays, do variable assignment and define custom functions in expressions
- Support for numeric pretty format using Numeral.js (ex:
0,0.00) - Support for date pretty format using Moment.js (ex:
YYYY-MM-DD) - Support for column alignment (ex:
left,right) - Support for template rendering using Handlebars (ex:
<strong>{{value}}</strong>) - Template can reference other columns (ex:
<span style="color: {{col0}}">{{value}}</span>) - Template can reference another column by its label (ex:
<span style="color: {{col['color']}}">{{value}}</span>) - Template can encode a value to render it as a URL parameter (ex:
<a href="my-dashboard?param={{{encodeURIComponent value}}}">{{value}}</a>) - More documentation here
- Filter table lines based on a computed formula (ex:
col0 > 0)- More documentation here
- Hide some table columns (ex:
0,1,Col2 Labelhides columns 0, 1 and the column labeled 'Col2 Label')- Note that the column label must be written as is (including whitespaces), with no surrounding quotes.
- Column labels containing commas are not supported since the comma is used to separate the columns
- It is recommended to use column labels to hide columns rather than their indices. Using the 'Split cols' feature, in fact, indices might depend on the global timerange that has been set.
- Add a filter bar (ex: when user enters
catfilter, it will display only rows that contain "cat")- Works also with numeric and date columns
- Ability to enable case sensitive filter
- Ability to make filter bar hideable
- Ability to filter as you type
- Ability to filter each term separately
- Ability to highlight filter results
- Ability to define filter bar width
- Support for a new bucket type : 'Split Cols'. It lets to create a pivot table
- When combined with computed columns, each computed column can be added per split column or after all split columns
- Hide export links (when checked, it will hide "Raw" and "Formatted" export links)
- Add a total label on total line first column (ex:
Total:) - Kibana supported versions : all versions from 5.5 to 7.5
Every release package includes a Plugin version (X.Y.Z) and a Kibana version (A.B.C).
- Go to releases and choose the right one for your Kibana
- launch a shell terminal and go to $KIBANA_HOME/bin folder
- use Kibana CLI to install :
- directly from Internet URL :
$KIBANA_HOME/bin/kibana-plugin install https://github.com/fbaligand/kibana-enhanced-table/releases/download/vX.Y.Z/enhanced-table-X.Y.Z_A.B.C.zip - locally after manual download :
$KIBANA_HOME/bin/kibana-plugin install file:///path/to/enhanced-table-X.Y.Z_A.B.C.zip
- directly from Internet URL :
- restart Kibana
Common features available for 'Computed Column Formula' and 'Lines Computed Filter':
- Support for expr-eval expressions
- Ability to reference total hits count returned by ES query (ex:
col0 / total * 100) - Ability to reference a column by its label (ex:
col['Sum of duration'] / col['Count']) - Column reference validation (by number or label), with error notification
- Formula validation, with error notification
- Support for pre-defined functions provided by expr-eval
- Additional custom functions listed in table below (ex:
col['Expiration Date'] > now() ? 'OK' : 'KO')
| Function | Description |
|---|---|
| encodeURIComponent(str) | Encodes the provided string as a Uniform Resource Identifier (URI) component. |
| indexOf(strOrArray, searchValue[, fromIndex]) | Returns the index within the calling String or Array object of the first occurrence of the specified value, starting the search at fromIndex. Returns -1 if the value is not found. |
| lastIndexOf(strOrArray, searchValue[, fromIndex]) | Returns the index within the calling String or Array object of the last occurrence of the specified value, searching backwards from fromIndex. Returns -1 if the value is not found. |
| now() | Returns the number of milliseconds elapsed since January 1, 1970 00:00:00 UTC |
| replace(str, substr, replacement) | Returns a new string with first match of substr replaced by a replacement. Only the first occurrence will be replaced. |
| replaceRegexp(str, regexp, replacement) | Returns a new string with all matches of a regexp replaced by a replacement. All the occurrences will be replaced. |
| search(str, regexp) | Executes a search for a match between a regular expression on 'str' String. Returns the index of the first match or -1 if not found. |
| sort(array[, compareFunction]) | Sorts the elements of an array in place and returns the sorted array. A compare function can be provided to customize the sort order. Example for an array of numbers: comparator(a, b) = a - b; sort(col0, comparator) |
| substring(str, indexStart[, indexEnd]) | Returns the part of the string between the start and end indexes, or to the end of the string (if no index end is provided). |
| toLowerCase(str) | Returns the calling string value converted to lowercase. |
| toUpperCase(str) | Returns the calling string value converted to uppercase. |
| trim(str) | Removes whitespace from both ends of a string. |
| uniq(array) | Removes duplicates from provided array so that array contains only unique values. |
Versions and Release Notes are listed in Releases page
This Kibana plugin is inspired from computed-columns and kbn_searchtables plugins.
Thanks for their great work !
To run enhanced-table plugin in development mode (that enables hot code reload), follow these instructions:
- execute these commands :
git clone https://github.com/elastic/kibana.git
cd kibana
git reset --hard vX.Y.Z # replace 'X.Y.Z' by desired Kibana version
mkdir plugins
cd plugins
git clone https://github.com/fbaligand/kibana-enhanced-table.git enhanced-table- install the version of Node.js listed in the
kibana/.node-versionfile - ensure that
nodebinary is both inPATHenvironment variable and inkibana/nodefolder - install the latest version of yarn
- execute these commands :
cd kibana
yarn kbn bootstrap
cd plugins/kibana-enhanced-table
yarn install
yarn start- in your browser, call
http://localhost:5601and enjoy!
To build a distributable archive, execute this command :
yarn build --kibana-version X.Y.Z # replace 'X.Y.Z' by desired Kibana versionIf this plugin helps you and you want to support it, you can give me a cup of coffee :)
