Data Points outside time range for mysql db

Grafana Time Series Panel
1

image
image1920×1032 133 KB

In the above image if you see … i have data points but still its showing data points outside range .

SELECT
Epoch_Timestamp time_sec,
Message_Count as value,
kafka_Topic as metric
FROM activevsdown where Kafka_Cluster_Alias in ($Kafka_Cluster_Alias) and
Interface_Name in ($Interface_Name) and Kafka_Topic in($Kafka_Topic) ;

2

Hi,

You need to add time range filter, i.e

AND $__unixEpochFilter(Epoch_Timestamp)

It’s always a good idea to order the result by timestamp as well.

Marcus

3

Thanks for the quick reply .
It worked :):star_struck:

4

SELECT
__unixEpochGroupAlias(data_nim,__interval),
data_nama_program_studi AS metric,
count(data_id_periode) AS “data_id_periode”
FROM mahasiswa
WHERE
data_id_periode = 20181
GROUP BY 1,2
ORDER BY __unixEpochGroup(data_nim,__interval)

how about it…