Status summary for machine

[juanitomaille]

Hello,

[ 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.

doing

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 ?

thks

[mattabrams]

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

show-inspect-data

[juanitomaille]

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

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

[juanitomaille]

goes to grafana 8.4.4 and influxDB 2.2.

Solved the problem with flux.

[grant2]

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