Status summary for machine


[ i simplified my post]

I need to use Elapsed() function for a very simple data recording below

I do this query :

SELECT elapsed("state") FROM "QUASER"

the result is :

It’s what I want but I loose the state column.


SELECT state, elapsed("state") FROM "QUASER"

doesn’t work.

I’m using an old version of influxDB (1.6.x)
I see in the docs that the 1st query should return what i want (time+elapsed(state)+state)

Is it a problem of version ?
If yes, can I do that without upgrading ?


can you please follow these steps to share your raw unformatted data? That way, the community can try and mock up your problem :+1:

1 Like

adding GROUP BY “state” doesn’t work too.

SELECT elapsed("state", 1s) AS "time_spent" FROM "QUASER" GROUP BY "state"

goes to grafana 8.4.4 and influxDB 2.2.

Solved the problem with flux.

For the benefit of others on this forum, could you share your Flux query?