Hi, is there mean to not have this disturbing message ‘data points outside time range’ from the graph ?
1 Like
What datasource are you using??
This message is because you are not properly configuring your query.
Hi,
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 :
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’
ORDER BY 1,2
$Server=
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
the graph).
Exemple :
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”
Regards
Philippe Michaud
Ingénieur d’exploitation
Prosodie-Capgemini
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
1 Like
Hi,
Thank you for the answer, the timefilter fix my problem.
Regards.
Philippe Michaud
Ingénieur d’exploitation
Prosodie-Capgemini
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:
SELECT
$__timeGroupAlias(country,$__interval),
country AS metric,
count(mmsi) AS number
FROM historico
WHERE
country != ‘NA’
GROUP BY 1,2
ORDER BY number desc
limit 20
and I get this representation that works as I want but with that message.
Thank you!
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:
query is:
SELECT
CREATED_TIMESTAMP_UTC as “time”,
sum(X) as value,
Y
FROM TRADE_DATA
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
my query:
SELECT (sum(“up”) / MEAN(“total”))
FROM
(
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.