search

kumaravel29 / grafana-sankey-panel

Sankey Diagram plugin for Grafana
MIT License
65 stars 12 forks source link

Using sql query display nothing on the panel #49

Open falenl opened 3 years ago

falenl commented 3 years ago

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?

gavin20 commented 2 years ago

Ditto - I tried various sql query formats, including from the pie chart plugin which this was inspired from - no luck rendering data. The table view displays data, which tells me the query is aok. I'm using Grafana v8.0.6 (68fe9e3431). Could you provide a working example?

kumaravel29 commented 2 years ago

Hi @falenl , I have not tried with SQL query. I have got this working with Elasticsearch queries where the data is grouped on keywords.