I'm pretty sure this is going to be very obvious but it's one of those days again.
I've a field Duration_Seconds to establish length of calls going through the system. I'm trying to display say the top 20 longest calls, however, whatever I try, it basis the results on total count, not length.
So even if I have a hundred calls at 30 seconds long that's not what I'm after, I,m after the individual call at 12257 seconds, 10545 seconds, 10140 seconds etc. However, if I have 5 calls at 900 seconds, I still need to see those as separate instances.
Does that make sense?
The search I'm using is:
host=*|search Code_Dialled=9 Duration_Seconds=* |sort - "Duration_Seconds"
which gives me it as a search, it's the last bit I'm stumped on.
Thanks again,
Stu..
... View more