Grafana Datatable Panel

This panel plugin provides a Datatables.net table panel for Grafana 3.x/4.x

Screenshots

Paging enabled

Scrolling enabled

Light Theme with Paging

Numbered Rows and Compact Style

Options

Options Tab

Same options as built-in table panel

Datatable Options Tab

Table Display Options

• Font Size - set font size of table content
• Scroll - toggle for scrolling vs Paging
• Paging Options
  • Rows Per Page - number of rows to display when paging is enabled
  • Paging type - multiple navigation options

Column Aliasing

• Override the name displayed for a column

Column Width Hints

• Provide a width "hint" in percentage or pixels ( 100px or 10% ). Note: The table will autosize as needed, but will use the hints provided.

Column Sorting

• Sort table by any number of columns in ascending/descending order.

Table Options

• Row Numbers - toggle to show row numbers
• Length Change Enabled - top left dropdown for showing alternate page sizes
• Search Enabled - toggle to allow searching table content (regex is enabled)
• Info - Displays the "Show N of X entries" on bottom left of table
• Cell Borders - show borders around each Cell (cannot be enabled with Row Borders)
• Row Borders - show border between rows
• Compact Rows - uses less padding for denser data display
• Striped Rows - non-colored rows will be "striped" odd/even
• Order Column - Highlights the column used for sorting
• Hover - Highlights row on mouse hover

Theme Settings

• Basic theme is currently the only option, more to be added

Thresholding

Row-based threshold coloring

Cell based threshold coloring

Cell based threshold value coloring

RowColumn threshold coloring

This option sets the row color to the "highest" threshold found for all cells in row.

It also sets the color for each cell according to the threshold (you can tell which columns actually exceeded the threshold).

This means - a row can have an overall color, with each cell indicating it's real threshold color.

RowColumn threshold coloring including row counter

Same as above, but with row counter included

---

Features

• Feature parity with built-in Grafana Table Panel
• Row coloring uses the "highest" threshold color of all columns
• New "RowColumn" threshold color option: Sets color to "highest" threshold found for all cells in row. Also sets color for each cell according to the threshold. This means - a row can have an overall color, with each cell indicating it's real threshold color.
• Set font size for rows
• Scrolling
• Paging
  • Preset page sizes
  • Multiple paging types
  • Dropdown for page size
• Row Numbers reactive to filtering
• Searchable table content (filtering), regex enabled
• Columns names can be aliased
• URLs inside row text can be "clicked"
• Rows can have a click-through URL
• Multi-Column Sorting
• Horizontal scrolling enabled when columns are wider than panel

TODO

• [+] Column is not working
• Add Additional Themes
  • Bootstrap:
    • Requires a modified .js file since it looks for "datatables.net" - need workaround
  • Foundation:
    • Requires a modified .js file since it looks for "datatables.net" - need workaround
    • Needs a new CSS that is "dark" for Grafana - the builtin is light http://foundation.zurb.com/sites/download.html/#customizeFoundation
  • JQueryUI ThemeRoller
    • Requires a modified .js file since it looks for "datatables.net" - need workaround

Building

This plugin relies on Grunt/NPM/Bower, typical build sequence:

npm install
bower install
grunt

For development, you can run:

grunt watch

The code will be parsed then copied into "dist" if "jslint" passes without errors.

Docker Support

A docker-compose.yml file is include for easy development and testing, just run

docker-compose up

Then browse to http://localhost:3000

External Dependencies

• Grafana 3.x/4.x

Build Dependencies

• npm
• bower
• grunt

Acknowledgements

This panel is based on the "Table" panel by GrafanaLabs

Changelog

Version	Changes
0.0.1	first release
0.0.2	NEW: Added option for a cell or row to link to another page
	NEW: Supports Clickable links inside table
	BUGFIX: Fixed missing CSS files
	BUGFIX: CSS files now load when Grafana has a subpath
	NEW: Added multi-column sorting - sort by any number of columns ascending/descending
	NEW: Column Aliasing - modify the name of a column as sent by the datasource
	NEW: Column width hints - suggest a width for a named column
0.0.3	BUGFIX: Saving State should now work - wrong option was in the datatable constructor
	NEW: Export options for Clipboard/CSV/PDF/Excel/Print
	BUGFIX: Columns from datasources other than JSON can now be aliased
	BUGFIX: No data now clears table (issue #5)
0.0.4	NEW: Now autoscrolls horizontally if number of columns is wider
	than then rendered panel (issue #6)