search

gbrian / grafana-simple-sql-datasource

Grafana SQL datasource
MIT License
62 stars 20 forks source link

Multiple metrics in table #30

Closed AhmedAzzabi closed 6 years ago

AhmedAzzabi commented 6 years ago

Hi, first of all thank you for this plugin, i wanted to know if let's say i have table weather with many metrics like temperature, wind, humidity, and datetime, how i can display them as metrics, do i have to create different rows ? each one is separate select : like select 'temperature' , temperature, dt from weather then another one for raint ,.... or is there a way with single select ? thank you in advance

buiductri commented 6 years ago

Hi @AhmedAzzabi , have you referred #21 yet? I have an example in that thread that may suit your need. Take a look at it. ;)

AhmedAzzabi commented 6 years ago

Thank you very much, Yep that solves the issue basically the query have to return 3 columns Metric for metric name, Value and Time so if i have multiple metrics to show, i have to flatten them to that format. Thanks