topic Re: DQL to Show Elapsed Milliseconds Over a Certain Amouny in DQL

DQL to Show Elapsed Milliseconds Over a Certain Amouny

Gib80 — Tue, 15 Oct 2024 12:06:53 GMT

Hi All,

Is it possible to create a summary that would show the elapsed seconds that went over 5 seconds for example? I have a column which shows the elapsed seconds fields.

Thanks

Re: DQL to Show Elapsed Milliseconds Over a Certain Amouny

krzysztof_hoja — Tue, 15 Oct 2024 14:24:24 GMT

I hope it helps:

data record(etime=1s), record(etime=4s), record(etime=5s), record(etime=6s), record(etime=6s+500ms) | fieldsAdd etime_over5s=if(etime>5s, etime-5s, else:0)