Hi, is there mean to not have this disturbing message ‘data points outside time range’ from the graph ?
What datasource are you using??
This message is because you are not properly configuring your query.
Thank you for your answer, I get data on the graph so the datasource (database is postgresql 9.4.10) should be OK (see jpgs attached).
The query is :
metric_date AS “time”,
metric_name AS metric,
WHERE domain=‘A’ and hostname=’$Server’ and application=’$Instance’ and metric_name not like ‘Applications’
ORDER BY 1,2
select distinct hostname from aometrics.prequestors_stats
$Instance=select distinct application from aometrics.prequestors_stats where hostname=’$Server’
We may have no data or partial data or old data for some metric_name on this kind of table (in this case I would like to get no information on
time metric1 metric2 metric3
t1 data11 data21 nodata
t2 data12 nodata nodata
t3 data13 data23 nodata
I would like in this case :
A graphe for metric1
A graphe with no values for t2 for metric2
No graphe for metric3
And no message “data points outside time range”
Tel.: +33 1 34 49 06 79
Envoyé : dimanche 9 juin 2019 20:56
You must edit thet query to:
SELECT metric_date AS “time”, metric_name AS metric, metric_value FROM aometrics.prequestors_stats WHERE domain=‘A’ AND hostname=’$Server’ AND application=’$Instance’ AND metric_name not like ‘Applications’ AND $__timeFilter(metric_date) ORDER BY 1,2
Thank you for the answer, the timefilter fix my problem.
Tel.: +33 1 34 49 06 79
Envoyé : mardi 18 juin 2019 22:42
select CAST(CAST(CreatedDate as DATE) AS DATETIME) AT TIME ZONE ‘India Standard Time’ as time,
count(ID) as ‘count’ from table IL
where ID=4 and
CreatedDate BETWEEN DATEADD(MINUTE,330,__timeFrom()) and DATEADD(MINUTE,330,__timeTo())
group by CAST(CreatedDate as DATE)
order by 1 desc
it is giving me data outside time range. Do you guys have any suggestion?
Hi, may be something like : select time, count from ( your_select_syntax ) as foo where $__timeFilter(time)
Hi, I am having the same problem with the message “Data outside time range” in my graph panel. I realise that I am not representing any time data. I just want to present number of count(mmsi) vs country.
The sql query that I have is this one:
country AS metric,
count(mmsi) AS number
country != ‘NA’
GROUP BY 1,2
ORDER BY number desc
and I get this representation that works as I want but with that message.
The problem is that in the background, grafana changes it into a very specific timestamp which renders all of my results out of range.
Having same issue:
CREATED_TIMESTAMP_UTC as “time”,
sum(X) as value,
WHERE SECURITY_ID IN ($SECURITY)
AND Y IN ($Y)
AND Z = “STRING”
AND A IN ($A)
AND B IN ($B)
AND C IN (C) AND D = 'STRING2' AND __timeFilter(CREATED_TIMESTAMP_UTC)
GROUP BY Y
Data source is MySQL, version is 6.7.0
Thank you, just one AND condition did the trick.
same problem tried to solve it myself but cant solve it
the graph is good, its just the message
SELECT (sum(“up”) / MEAN(“total”))
SELECT count(“bedTemperatureMeasured”) AS “up” FROM “temperature” WHERE (“originID” =~ /LM/) AND (“status” = ‘printing’ OR “status” = ‘eject product’) AND $timeFilter
SELECT count(“bedTemperatureMeasured”) AS “total” FROM “temperature” WHERE $timeFilter AND (“originID” =~ /LM/)
GROUP BY “originID” fill(null)
I was having the same problem. Where I was just wanting to return a single value, and use that in the an alert. So in the end hide it in the graph, and in the legend. looking at your group by statement you aren’t doing the exact thing I’m doing, but I hope this helps.
influx during aggregated calculations puts a epoch 0 stamp on it, so that sucked. What I did was take that single value query into “transform” and use “add field from calculation” function. Then just pick the single query as the field name, and use the calculation as “last”. That removed the warning for me, and gave me the view I wanted.