Can you please share sample OP from this?
| fields host Name Path DegradationTime
| stats max(DegradationTime) as DegradationTime by Path
I dont understand
something like this??
| stats max(DegradationTime) as "DegradationTime" by Path
| eval "DegradationTime" = round(('DegradationTime' / 1000),0)
| where DegradationTime>1
| rename DegradationTime as "Degradation time (seconds)"
yes it works now thanks