DQL to Show Elapsed Milliseconds Over a Certain Amouny

[Gib80]

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

[krzysztof_hoja · Accepted solution]

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)