search

GoshPosh / grafana-meta-queries

Grafana plugin for calculating time period metrics like week over week, month over month and year over year etc.
Apache License 2.0
284 stars 71 forks source link

MetaQueris doesn't seem to work with InfluxDB #113

Open stefi994 opened 3 years ago

stefi994 commented 3 years ago

I am looking into sum of 2 queries with are from InfluxDB with are GROUP BY time(30s), fill(null) and it's grouped by devices.

I am trying to get a sum of traffic by devices and when I select query from Meta Queries I am not able to see any result on the graph. I am trying with A['alias1']+B['alias2']

Tried to find if this is supported in Meta Queries but didn't find anything.

Another thing, is it Regex supported here ? Cause I would like to make a sum of all results from one Query.

For example A['in.'] + B['out.]

h07d0q commented 3 years ago

Same here. Only getting "No data" as result. Grafana v7.2.1 (72a6c64532) - seems the problem atm

IstvanPeter commented 3 years ago

I get error message also. image

Gauravshah commented 3 years ago

grafana 7 is work in progress https://github.com/GoshPosh/grafana-meta-queries/issues/104

Shotte commented 3 years ago

I have to apologize: after updating your plugin to the latest source and linking it to grafana (after uninstalling original plugin) everything seems to work properly. Thank you for your good work.

=== This is still an issue using Grafana v7.5.2 (ca413c612f) and inlfuxDB 1.8.4. I get "resultByQuery.data is undefined" and query inspector announces "Loading query inspector... O" with forever circling around...

My simple queries are: 1) SELECT last(value)-first(value) as in FROM Bezug WHERE $timeFilter 2) SELECT last(value)-first(value) as out FROM Einspeisung WHERE $timeFilter 3) A['out'] / B['in'] (arithmetic)

Is there any chance that you gonna fix it using influxDB? I would really appreciate this because influxDB has not really (elegant) workarounds for simple multi-measurement queries doing arithmetics.

Thankz in indvance.