cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DQL to Show Elapsed Milliseconds Over a Certain Amouny

Gib80
Contributor

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

1 REPLY 1

krzysztof_hoja
Dynatrace Pro
Dynatrace Pro

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)

krzysztof_hoja_1-1729002249661.png

 

 

Featured Posts