Query with "where" in "timeline"

1

Hello Guys.

i am new with grafana, my question is, how can i do a query, where i can selecting all time currently elapsed ( or total time) excluding any interval tags or simplly any tags?
something how : "SELECT totalTime FROM graph WHERE ‘id’ = ‘Y’ WHERE time != ‘tags’ ", in variables section.
I thank the attention.

2

I think this will fulfill your question

SELECT
StartTime as time,
StateEvent
FROM
Grafana_MachineState
where FullPath in ($SFullPath) AND Conv in ($Conveyor) AND Area in ($Area)
ORDER BY
StartTime ASC

1 Like
3

“FullPath”, “Conv” and “Area” are relative to what?
the “time of graph” is stored in Grafana_MachineState ?

4

i need something how: time interval from start to “now”( elapsed time) without the time range of the annotations in graphs, or just know how calculate elapsed time in graph.

5

I just posted a query structure
Fullpath and Conv are the names of columns which are stored in Grafana_machinestate again i used this name as a examples no such table is stored in grafana. Take this query just an example.

Read this

1 Like
6

Issue resolved or not?

7

I understood, would you know where the graphana stores elapsed time data, whether it is in grafana.db or in the browser’s web storage? if i have access to this data, i can do the calculations i need (MTBF - mean time between failures).

Thank you very much in advance