"No data points"

[ansumanm]

My query:

"q=SELECT first("ltp") AS "open", last("ltp") AS "close", min("ltp") AS "low", max("ltp") AS "high", difference(last("vtt")) AS "volume" FROM "ZFeedFull" WHERE ("symbol" =~ /^BANKNIFTY20JULFUT$/) AND time >= 1594957500000ms and time <= 1594979999000ms GROUP BY time(5m) fill(linear)"

If I change panel to graph, I get data:

My grafana version is 6.4

[asnakep]

Hello,

I have same "no data points" issue using prometheus.

Thank you, best regards, Emanuele

[wscardua]

Hi...

Me too .. to get data inside influx

SELECT first("open_price") FROM "trade_candle" WHERE ("coin" = 'BTCUSDT') AND time >= now() - 6h GROUP BY time(5m) fill(linear);SELECT last("close_price") FROM "trade_candle" WHERE ("coin" = 'BTCUSDT') AND time >= now() - 6h GROUP BY time(5m) fill(linear);SELECT max("high_price") FROM "trade_candle" WHERE ("coin" = 'BTCUSDT') AND time >= now() - 6h GROUP BY time(5m) fill(linear);SELECT min("value") FROM "trade_candle" WHERE ("coin" = 'BTCUSDT') AND time >= now() - 6h GROUP BY time(5m) fill(linear);SELECT max("volue") FROM "trade_candle" WHERE ("coin" = 'BTCUSDT') AND time >= now() - 6h GROUP BY time(5m) fill(linear)

Grafana Version: v7.3.7 (1e261642f4)

[Erraen]

This should be 4 separate requests, one for each value ('open', 'close', 'high', 'low'), rather than getting 4 values in one request. And aliases of column should be exactly 'open', 'close', 'high', 'low' - that is hardcoded in source. Its works for me for timescale source.

Grafana Version: 8.0.5