Data visualization with Ag-Grid for Apache Zeppelin
npm install zeppelin-aggridzeppelin-aggrid
===============
Data visualization for Apache Zeppelin using ag-Grid (rich table widget).
line 81 at ZEPPELIN_HOME/local-repo/vis/node_modules/zeppelin-aggrid/aggrid-transformation.js file in order to enable advanced ag-Grid options like Aggregation and Pivoting.Please, be aware you may ask ag-Grid for trial licence key which is valid during 3 month.
columnDefs in the according UI field. Unlike usual ag-Grid settings the data placed there should be a valid JSON, i.e. strings must be framed with double quotes except of numeric, boolean or null values. Example is shown below.``
{"columnDefs": [
{"field": "gold", "aggFunc": "sum", "enableValue": true, "width": 100},
{"field": "silver", "aggFunc": "min", "enableValue": true, "width": 100},
{"field": "bronze", "aggFunc": "max", "enableValue": true, "width": 100},
{"field": "country", "rowGroup": true, "enableRowGroup": true},
{"field": "year", "pivot": true, "enablePivot": true},
{"field": "date"},
{"field": "sport", "pivot": false, "enablePivot": true}
]}
Some points for setting data pivoting in this plugin can be done by the ag-Grid UI (e.g. Tool Panel), some things not.
To allow a column to be used as pivot column via the Tool Panel, set "enablePivot": true on the required columns definitions. Otherwise you won't be able to drag and drop the columns to the pivot drop zone from the Tool Panel.
Enable Pivot mode by switching eponymous checkbox on Tool Panel then.
Be aware that date column in the example above won't be shown, because nor aggregation, nor grouping, nor pivoting is enabled for it.
You can manage table column width by clicking the menu sign, which is appearing at the right of column name on mouse over.
You can choose aggregation function by clicking on field name in Values set on Tool Panel.