kumaravel29 / grafana-sankey-panel Goto Github PK

When a dashboard is selected and loads, the Sankey panel gives an error "google.visualization.DataTable is not a constructor". But once the dashboard is refreshed the panels display the sankey diagram properly.

Hello,

I would like to display a Sankey about the energy consumed in a building (grid & photovoltaic meter then repartition on level 1 sub meters then repartition on level 2 sub meters).

_field : Name of meters
_value : 10' consumption value
_time : time of the measure
CommandName : information measure into this meter
level : meter level (1=grid/PV, 2 main sub meters, 3 level-2 sub meters

The result is not correct.
What is the table format to send to the plugin to reach the goal ?

Best regards

Grafana complains "Error loading plugin", but I'm not seeing specific errors in the log file.

I'm having the exact same issue as #23. Same error messages, and installed it using:

grafana-cli --pluginUrl https://codeload.github.com/kumaravel29/grafana-sankey-panel/zip/master plugins install grafana-sankey-panel

It installed it to the right location and it says it was successful. Restarted Grafana and still get the same errors. Grafana log file doesn't show any errors though.

Hi,

Your project is really cool but I have a good suggestion. Why you don't build your js plugin with directly the google charts loader inside it ?
It's more simple to include your plugin into our grafana server using this and, in that case, we don't have to modify the index.html file

Thanks

can you update for grafana v8 bro ? if you can i will pay ^_^

Hi, Could you please update this plugin to support Grafana 7.X or 8.X

This is more like help wanted type of query. Sankey panel is loading and I can set up Metrics via wizard. But my problem is to get values in correct form from InfluxDB that Sankey-panel would show something else than undefined - NaN in legend.

So help is wanted in what form data needs to be queried.

I'm trying this panel recently, and I finally install it successfully. But I faced a problem that the graph did not show after I finished setting.

I wonder if it is the problem of my data format.
Here is what my data look like.

Thanks.

Hi,
When i am trying to use the plugin , i get following error below , the plugin is under
/usr/share/grafana/public/app/plugins/panel/sankey-panel

Please adice
Thanks

Plugin Error
Fetch error: 404 Not Found Instantiating http://192.168.1.150:3000/public/app/plugins/panel/sankey-panel/module Loading app/plugins/panel/sankey-panel/module

Error Loading Plugin
Check the server startup logs for more information.
If this plugin was loaded from git, make sure it was compiled.

Hi @kumaravel29 ,

I tried to install your plugin and using a simple sql query, but it doesn't display anything. Below are the query for testing:

select 'e1' as event1, 'e2' as event2, 'e3' as event3, 6, now() as time
UNION
select 'e1' as event1, 'e7' as event2, 'e4' as event3, 3 , now() as time

If I only use one section of the union, then I can see the sankey diagram. Can you help me how to use sql to show the diagram?

Nice plugin! Is it compatible with Grafana 6? If not, what would be necessary to integrate it? Thanks!

Thanks for your promising work. I was trying to test this by git cloning to /var/lib/grafana/plugins and adding loader.js to /usr/share/grafana/public/views/index.html to end of file.

On new dashboard I just see Sankey "loaded", displaying "Panel title" and from legends "current". But I cannot edit the dashboard to test it out.

Any help/tips how to fix or are you planning upgrades to later Grafana?

Hello, it's possible to have diagram examples with datasources usage ? I don't understand how to use it with elastic Search and graphite (if it's possible).

Thanks

Hi.

We have CloudWatch as data source and its working well for most of the standard plugins. We are looking for a SanKey panel and this is fantastic for us, but it doesn't show anything in the panel. We can configure and work with the panel (no issues on console) but probably the plugin require some data structure and maybe cloudwatch is different.

We want help and guidance to modify this plugin to adapt the plugin to a cloudwatch data source (we will publish the result in this GitHub for the community).

This is an example of query in our case.

Thanks in advance.

Regards.

Got this error in grafana 5.2.5, Chrome 69.0.3497.100, installed by cloning locally, mounting to plugins directory in docker.

angular.js:14700 ReferenceError: google is not defined
    at link (rendering.js:12)
    at SankeyCtrl.link (sankey_ctrl.js:180)
    at Object.link (plugin_component.ts:161)
    at angular.js:1385
    at angular.js:10539
    at Re (angular.js:10545)
    at ie (angular.js:9934)
    at angular.js:9174
    at angular.js:9039
    at dashboard_ctrl.ts:61 "<panel-plugin-sankey-panel dashboard="dashboard" panel="panel" class="panel-height-helper">"
(anonymous) @ angular.js:14700
(anonymous) @ angular.js:11142
Re @ angular.js:10547
ie @ angular.js:9934
(anonymous) @ angular.js:9174
(anonymous) @ angular.js:9039
(anonymous) @ dashboard_ctrl.ts:61
l @ dashboard_ctrl.ts:70
(anonymous) @ dashboard_ctrl.ts:104
Promise.then (async)
link @ dashboard_ctrl.ts:102
(anonymous) @ angular.js:1385
Re @ angular.js:10545
ie @ angular.js:9934
(anonymous) @ angular.js:9174
(anonymous) @ angular.js:9039
e.load @ folder_picker.ts:110
t.componentDidMount @ DashboardGrid.tsx:153
fa @ react-dom.production.min.js:214
da @ react-dom.production.min.js:206
la @ react-dom.production.min.js:205
Ro @ react-dom.production.min.js:201
enqueueSetState @ react-dom.production.min.js:131
y.setState @ react.production.min.js:13
i.strategisedSetState @ react-sizeme.js:308
(anonymous) @ react-sizeme.js:336
v @ index.js:160
(anonymous) @ index.js:170
x @ index.js:235
a @ element-resize-detector.js:161
(anonymous) @ element-resize-detector.js:236
A @ scroll.js:587
process @ batch-processor.js:123
c @ batch-processor.js:37
setTimeout (async)
(anonymous) @ batch-processor.js:82
(anonymous) @ batch-processor.js:83
l @ batch-processor.js:64
add @ batch-processor.js:24
C @ scroll.js:595
makeDetectable @ scroll.js:616
(anonymous) @ element-resize-detector.js:229
forEach @ collection-utils.js:14
listenTo @ element-resize-detector.js:197
value @ react-sizeme.js:395
value @ react-sizeme.js:346
fa @ react-dom.production.min.js:214
da @ react-dom.production.min.js:206
la @ react-dom.production.min.js:205
Ro @ react-dom.production.min.js:201
ya @ react-dom.production.min.js:219
ba @ react-dom.production.min.js:219
xa.render @ react-dom.production.min.js:228
(anonymous) @ react-dom.production.min.js:231
ga @ react-dom.production.min.js:217
Sa @ react-dom.production.min.js:231
render @ react-dom.production.min.js:233
(anonymous) @ ng_react.ts:173
$digest @ angular.js:18232
$apply @ angular.js:18531
(anonymous) @ angular.js:18832
h @ angular.js:6362
(anonymous) @ angular.js:6642
setTimeout (async)
i.defer @ angular.js:6640
$applyAsync @ angular.js:18831
(anonymous) @ angular.js:12544
w @ angular.js:12785
y.onload @ angular.js:12702
load (async)
(anonymous) @ angular.js:12685
(anonymous) @ angular.js:12492
(anonymous) @ angular.js:12244
(anonymous) @ angular.js:17051
(anonymous) @ angular.js:17095
$digest @ angular.js:18232
$apply @ angular.js:18531
(anonymous) @ angular.js:1952
invoke @ angular.js:5040
i @ angular.js:1950
Me @ angular.js:1970
(anonymous) @ app.ts:135
Promise.then (async)
t.init @ app.ts:130
1222 @ app.ts:42
i @ bootstrap:83
n @ bootstrap:45
111 @ bootstrap:218
(anonymous) @ bootstrap:218

When attempting to install the sankey panel in Grafana I get an error message in the Grafana visualization panel "Error loading: grafana-sankey-panel"

• I tried installing this in the same place as other Grafana plugins (/var/lib/grafana/plugins)
• The thumbnail for the sankey visualization plugin does appear in the Grafana visualization gallery options.
• Nothing particularly helpful in the grafana log

t=2020-04-29T23:40:10+0000 lvl=info msg="Registering plugin" logger=plugins name="Sankey Diagram Chart"

Tried this on a couple of Linux instances in fact (tried this on CentOS 7.6 and AMZN AMI)

Any ideas?

In the release 2.0.0. images
for example "/src/img/sankey-panel-query-example.png"

and the versioning is a bit confusing ... including the dependencies

This sankey data looks on top of each other, and no connection lines.

Installation on:
Debian VM, 4 core, 8GB of RAM

Grafana version:
10.4.2

Installation using grafana-cli : grafana-cli plugins install netsage-sankey-panel

Hello,

Great that this exists for Grafana :)

I would like to use this panel using MSSQL query as datasource

The data is organised as follows
starttime;origin;destination;countthem
t1;A;B;20
t1;A;C;10
t1,B;A;30
t1;B;C;40
t1;C;A;10
t1;C;B;30

The query would look something like this :

SELECT
$__timeGroup(starttime, '1h') AS time,
SUM(CAST(CountThem AS NUMERIC)) AS value,
origin, destination
FROM
mytable
GROUP BY
origin,destination,$__timeGroup(starttime, '1h')

I have tried multiple queries (e.g. format as table & ommitting all time related stuff), but I can't seem to get the visual working ...

What should the expected format of the data that the query has to return ?

I can't install it.

It's okay:

git clone https://github.com/kumaravel29/sankey-panel.git
sudo service grafana-server restart

I inserted this to the /etc/grafana/grafana.ini file, and after restart the Grafana server again.

[plugin.sankey]
path = /home/user.name/sankey-panel

Where is the Grafana index.html file?

I found an index.html file in this folder:

/usr/share/grafana/public/views

I try to insert the script to header or before the /body, and after restart the Grafana server. But I can't found 'Sankey' in graphs/plugins.

What is the problem? Why can't see it?

Version of the Grafana: Grafana v6.2.5