Scroll enabled not work Grafana v6.0.0

Given a metric with two dimensions, can I use this panel to show a table where columns are created from the values of one dimension, rows from the values the other, and the value of each cell is the current value (or aggregation) of the metric with that cell's coordinates?

As a real-world example, let's say I have a Prometheus data source. It provides the "up" metric, with labels "job" and "instance". I'd like to arrange the values of "up" into a grid for each job/instance combination.

If you create a link for a table cell, it does not put an underline style on it to indicate that it is a link. This feature is there in the grafana default table plugin.

Version 5.3.2 of grafana
Plugin v0.0.6

If I create a table and flag the "Dispaly Rownumbers" box, this column is not exported to csv

Hi,
i'm using your datatable plugin on grafana.

I'm trying to use it to edit some data (i know grafana is not supposed to be used like this but i'm not the one who asked for this ).

Every time i resize my browser's windows, the datatable is being reloaded so if I have some textarea , the data will be change by the one loaded by the datatable at first call on database.

Any way to help me with those ?

Thx

This panel tries to access the height via the row, this really the best/preferred way to do it (hence it does not work v5).

Just use ctrl.height (this.height) in the panel if you need the panel height.

https://github.com/briangann/grafana-datatable-panel/blob/master/src/ctrl.js#L397

Hi,

I'm trying to use this panel as it has a lot more features than standard table. I'm running into an issue where if a template variable is present, and its changed from its initial value to a variable which does not have any values (in specified time period), the table does not update and continues to show the old data.

Steps to reproduce:

1. Select a template variable which will return data values in the specified time period
2. Add a datatable panel
3. Select Elasticsearch datasource
4. Create query with option: "name:$Template_name", raw_document
5. Additional options: (scrolling, search enabled)
6. Exit from Edit screen
7. The table should populate
8. Select a template variable value which does not have any entries in the specified time period.
9. The table will continue to show the old data rather than cleaning up entries.

Let me know if more information is required!

Thanks.

when I set a field in "Santize html" the following error is displayed:

Tank You.

TypeError: this.sanitize is not a function
at DatatableRenderer.defaultCellFormatter (http://127.0.0.1:3000/public/plugins/briangann-datatable-panel/renderer.js?bust=1505264066323:105:27)
at Array.eval (http://127.0.0.1:3000/public/plugins/briangann-datatable-panel/renderer.js?bust=1505264066323:160:29)
at DatatableRenderer.formatColumnValue (http://127.0.0.1:3000/public/plugins/briangann-datatable-panel/renderer.js?bust=1505264066323:176:49)
at DatatableRenderer.generateFormattedData (http://127.0.0.1:3000/public/plugins/briangann-datatable-panel/renderer.js?bust=1505264066323:192:34)
at DatatableRenderer.render (http://127.0.0.1:3000/public/plugins/briangann-datatable-panel/renderer.js?bust=1505264066323:416:38)
at renderPanel (http://127.0.0.1:3000/public/plugins/briangann-datatable-panel/ctrl.js?bust=1505264066323:442:24)
at f.eval (http://127.0.0.1:3000/public/plugins/briangann-datatable-panel/ctrl.js?bust=1505264066323:450:17)
at f.emit (http://127.0.0.1:3000/public/app/boot.js:61:19558)
at a.emit (http://127.0.0.1:3000/public/app/boot.js:61:21443)
at DatatablePanelCtrl.a.render (http://127.0.0.1:3000/public/app/boot.js:55:9422)

Hi Brian,

I would like to ask how to add action buttons (view, edit, delete) for each record in datatable panel like in the image below.

if a user click View then I would like to perform a function
if a user click Edit then I would like to perform a function
if a user click Delete then I would like to perform a function

Thank you in advance Brian!

Grafana v5.0.3
Datatable Panel v0.0.6

Column Set Up:

Link on Hover:

Can I add data from other columns like the vanilla Grafana Table too. e.g $__cell_6?

no mater chose Length Change Enabled or not , it don't work . what's wrong

Hi,

data table seems to be a very nice table plugin for grafana with many useful features.

I wonder if it would be possible to add a stats summary below the data table itself, maybe as a second table below.
Something like the following picture:

As far as i see, there is a model for the table data, is it possible to enhance the model to fullfill the above idea?

kind regards
Bernd

Please,

I did try use Datatable in Grafana but I found error in the order column.
I don't found as add column order registers and also doesn't work if I try use "ORDER BY data DESC" in my SQL sintax.

What I have to do?

Hi,

This is a great plugin, search& no. of entries in dashboard itself is a great future in this plugin even grafana table doesn't have.

I'm trying for below screenshot:

I obtained:

Hi,

In fact, I'm trying to put your plugin in Grafana v6, and I'm trying to find a way to switch languages.

I downloaded the French.json file available here: https://datatables.net/plug-ins/i18n/French

And I'm trying to find out how to use it for the Grafana plugin. I think that might be helpful for some of us trying to do the same.

Thank you for your reply.

Because the earlier column style rule would be overridden by the latter rule, the time(the number of milliseconds) data get the number rule in default option below:

This makes date convert error.

You can revert two rule to resolve this problem.

It's currently possible to use $__cell in the url input box as a way to use a cell's content to generate its hyperlink. In some cases however, it may be desirable to use only a portion of the content. It may also be desirable to use separate portions of the cell's content in separate portions of the url.

I propose adding a Parameterization input which takes a regular expression which will be used to split the cells content. After splitting we could provide variables similar to the $__cell_n variables.

Copied from: grafana/grafana#11066

If it helps, I created an implementation once before for the core table panel. It used a 'Parameterize by' input box that took a regex to split the string. Once split the $__pattern_n variables could be used in the Url input box to generate the url.

As an example, we have the target name set as a comma separated string. By breaking up the parts we're able to link each row to a separate dashboard and pre-populate the required template variables.

Original: grafana/grafana#11068

Greetings
is there any possibility to implement compatibility with this standard "Table" panel feature?
http://docs.grafana.org/features/panels/table_panel/#merge-multiple-queries-per-table

As far as I can see from DevTools datatable panel sends only one query (the first in a row) and ignores others.

Thank you in advance

P.S. InfluxDB is used as the data-source

Hey,

Thanks for the great work on the Datatable panel looks amazing. I am facing some issues on time series updates on the panel, it seems it does not listen to change properly. any work around ?

Hi ,

After configuring few columns , when set the last field coloring to cell, mess all the table.
Using grafana v6 .

If set it to disabled or cell, then the cell background becomes OK, but the text become colored.

Some of the DataTable options is not working

these options is not working if I click on them nothing happens
If not avilble then gray them out

A panel with the scroll (instead of paging) option enabled ends up overflowing the panel view.

Resizing the panel larger to show bottom bounds (to include the bottom scrollbar arrow, table, and "Showing # to # entries of # entries") is only a temporary/momentary solution. Upon refresh the content in the panel again overflows the, now larger, view.

An image showing an example of the problem:

• Left: after resizing and saving the dashboard with the new panel size.
• Right: after refeshing the page.

Dear developers:
I was used this plugin to show table data ,it is so cool and beautiful.
but when I wan to show more data , issue is comming. Whole tool came so stucked, the data loading need about 7 seconds, but I should spend lots of time to wait it response. Any Button or Event need wait long time. If you have an better plan to slove this,Please touch me .
Thank you very much.

Not really an issue, but more of a question.

Is this project abandoned and should i move on to something else?
It's clearly not working as intended in Grafana 6 and the last commit is months ago.

It would be nice to increase the width of the search bar to clearly see the entire search criteria. Indeed, most of time users use multiple long keywords and with the actual width it is not possible to clearly see the entire search criteria. Ideally the size of the search bar should be the same as the table.

Hello

Would bevery apreciate to have a feature to map values to names or strings like in single stat panel , i have a big panel with hundred of alerts and a dashboard with a table solve this problem .

Make a huge diference.

Feature like this

From grafana community message board:

• Column Aliasing is not working, upon clicking Add Column Alias, there is no response
• Column Width Hints is not working, upon clicking Add Column Width Hint, there is no response
• Column Sorting (applied top to bottom), upon clicking Add Rule there is no response

When I click on buttons Add Column Alias, Add Column Width Hint or Add Rule nothing happens. This issue is after upgrade to 0.0.3 and 0.0.4. Anybody else with this issue? Thanks

When set the Unit to duration(s) and put any threshold value , the panel check over the unit value recalculated and not over the original value.
Since this unit can show in multiple levels (seconds, minutes, hours) the threshold isn't check correctly and then do not change the colors correctly.

Using grafana 6.x .

you list the following as a feature

• Rows can have a click-through URL

But I don't see where I can configure the url

Hi there,

I'm using this panel to list a number of hosts and it's ip_address that come from 4 different Mysql databases so I can use the Search text that comes with the pannel.
On the Metrics tab:

• Datasource: Mixed
• Queries are the same just pointing out to the different mysql dbs I have.

Results are showed in a table, but limited :(

When I have more than 8000 lines...
:(

Why is this happening?
Any help would be appreciate.
Thanks in advance,

Alba.

Great DataTable panel with search function, what is ultimate feature compared to standard Grafana plugin offering. However, the sorting does not work on number columns. It seems to do alphabet sorting. The Grafana "Table" panel, sorting works.

Here is snip of JSON table data what is returned from my backend,
[{
"type": "table",
"columns": [{
"text": "ITEMID",
"type": "string"
}, {
"text": "PRODGRP2_NAME",
"type": "string"
}, {
"text": "NAME1",
"type": "string"
}, {
"text": "STOCKLOC",
"type": "string"
}, {
"text": "UNIT",
"type": "string"
}, {
"text": "QTY",
"type": "number"
}, {
"text": "LOCPRICE",
"type": "number"
}, {
"text": "TOTALVALUE",
"type": "number"
}],
"rows": [
["501816-M39-280", "Bolts", "M39x280A193-B7/2HStud bolt with two hexagonal nuts", "blah", "pcs", 165.0, 10.43, 1720.95],
....
...

I have the following setting in my grafana.ini

root_url = %(protocol)s://%(domain)s:%(http_port)s/grafana

That means that my grafana url looks like http://myserver/grafana

Hoever when I try to use datatable-panel plugin I see the following in js console of my browser:

[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (jquery.dataTables.min.css, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (datatable-dark.css, line 0)
[Error] Potentially unhandled rejection [3] (SystemJS) Error loading CSS file.
        onerror
        Error loading http://myserver/public/plugins/briangann-datatable-panel/libs/datatables.net-dt/css/jquery.dataTables.min.css!http://myserver/grafana/public/app/core/utils/css_loader.js
        (anonymous function) (boot.4aeac494.js:5:27838)
        f (boot.4aeac494.js:5:27434)
        i (boot.4aeac494.js:5:27723)
[Error] Potentially unhandled rejection [6] (SystemJS) Error loading CSS file.
        onerror
        Error loading http://myserver/public/plugins/briangann-datatable-panel/css/datatable-dark.css!http://myserver/grafana/public/app/core/utils/css_loader.js
        (anonymous function) (boot.4aeac494.js:5:27838)
        f (boot.4aeac494.js:5:27434)
        i (boot.4aeac494.js:5:27723)
[Error] Failed to load resource: the server responded with a status of 401 (Unauthorized) (query, line 0)

Seems like Grafana Datatable Panel ignores grafana root_url setting.

Can you please help me solve this issue?

Thank you!

Regards,
Sergey

Hi, I'm trying to pass HTML elements (a button, list...) in one of my columns, I pass the code as "string".

Although the HTML tags are escaped so the cells only contain text. Is the plugin using Grafana's methods ? Escaping HTML was added here : grafana/grafana#4596 (comment)

Thank you very much for your work and help ! :)

I am unable to get any of the colors to show in the datatable panel

Grafana 4.3.0-pre1

successful
npm install
bower install

Hello,

Thanks a lot for this plugin, it is amazing.
It is maybe something you have already seen but nothing happens when I click on one of the new features. I checked the log and nothing neither.
I am using ElasticSearch or MySQL sources.

Do you know what might cause the issue ?

Thanks a lot,
Kry

Hi,

I have a Problem with the Plugin. If a linebreak is needed to display the data, the rendering of the paging elements fails or they are not visible. See the two screenshots.

Is there a way to fix this using the options? I'm using version 0.0.6 and Grafana version 5.2.3.

Thank you for your time !

Is there any way to enable both pagination and scroll feature? Suppose I set the number of rows to 100 on one page, but since there is no scrolling available, it's impossible to go to the bottom of the page.

Hello @briangann,

I have updated our grafana plugins last week and our datatable panel using dashboards do not work after that. We get the error below. How can we solve this issue?

TypeError: this.stringToJsRegex is not a function
at Array.t.defaultCellFormatter (http://our_server_url/public/plugins/briangann-datatable-panel/module.js:23:4377)

Whenever I set the Time column type as Hidden...

I get this error, that shows up constantly

Hi Brian,

I'm new to Grafana and am trying to use the native Table as well as your Datatable Panel.
My table has many columns (wider than panel). While I can use your scrollbar to scroll data left/right, the header row does not track with the data.

How can I get the header to scroll?

Thanks!

Hi ,

I have enabled paging option but not working in grafana V5.4.3

I only saw scrolling mode always.

how can I do to solve this problem?

Thanks

Version 5.3.2 of grafana
Plugin v0.0.6

I can not find the option to export to Excel / PDF
I see in the release notes that from version 0.03 it was a new feature

Hi,

Do you think it's posible to publish the plugin to Grafananet ?

That way it would be easier to update it.

Thanks in advance.

Version 5.x of grafana
Plugin v0.0.3

Issue:
The export csv function appears to have a bug in it.. I tried hacking up the code to no success following grafana/grafana#2401 to make it a , delimited vs a ; delimited file so that excel opens it correctly.

Sample export string

instance_id;AZ;;Launch Date;Created On;Architecture;Owner;Portfolio;UserID;VP;Type;

BTW I LOVE the custom option as this is my go to plugin for tables

grafana-datatable-panel search bar are still some minor problems with it.As shown in the picture, it will show incomplete when there is more content. My grafana version v5.2.1

Hello!
There is an issue with sorting.
It works by digits, but no by values.

Kindly ask you to fix it in short time.
Thank you!

We tried the following command to install datatable panel
grafana-cli plugins install briangann-datatable-panel, but we couldn’t able to see in the datatable panel in the dashboard after performing the command. Could you please help us. Thanks!

can not using $host which i defined this variable in the dashborad scope

and what's the "split cell" means , and how to use it ?