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?
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:
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?