Datapoint not showing grafana

Hello All,

I have created python script that can create database and add tag and field

I have added data source on grafana (working Good) . I can see tags and field . Also added graph but i cant see data point.

Can you please help me? How to start troubleshooting ?

Can you please show us the query you are using?

1 Like

thanks for your reply.

there are four graphs i am using following query for one graph

xhrStatus:“complete”

request:Object

method:“GET”

url:“api/datasources/proxy/6/query”

params:Object

db:“mtr_pi”

q:“SELECT “avg” FROM /^facebook.com$/ WHERE (“location” =~ /^sj-raspberrypi1$/) AND time >= now() - 5m GROUP BY “hop””

epoch:“ms”

data:null

precision:“ms”

response:Object

results:Array[1]

0:Object

Hmm, the period in /^facebook.com$/ and the dash in /^sj-raspberrypi1$/ may be causing problems with your regex. Try changing your query to

SELECT "avg" FROM /^facebook\.com$/ WHERE ("location" =~ /^sj\-raspberrypi1$/) AND time >= now() - 5m GROUP BY "hop"

in the query editor.

Also, is avg its own measurement on your InfluxDB?

Useful resources:
http://docs.grafana.org/features/datasources/influxdb/

1 Like

I have tried what you suggested.

But it didnt work.

i have another dashboard with same query but different locations . that dashboard works fine.

In this dashboard if i tried
SELECT “avg” FROM /^facebook.com$/ WHERE (“location” =~ /^sj-raspberrypi1$/)

it showing me all the values, but if i try to add time in the query it is not showing me anything .

I guess I have some issue with the time series.

any guesses what could be the reason?

Thanks

How does your query look like when you try to add time?