Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
please find the attachment, here i need average from >4
Advanced Thanks
Average with respect to what...?
What is the output you are looking for?
I guess Avg of the AVERAGE field where it is greater than 4 minutes?
Load AVERAGE From FileName
Where Time(AVERAGE) >= Time#('00:04:00','hh:mm:ss');
May be this?
Avg(If(AVERAGE > MakeTime(0, 4), AVERAGE))
Hi Manish,
sort the data "descending" and calculate the average from 0:05:00 to END-TIME.
Hi Sunny,
please share with my data.
sort the data "descending" and calculate the average from 0:05:00 to END-TIME(0:16:00)
ex:
calculate the 0:16:00 to 0:05:00
Hi Sunny,
your condition is current i got the exact output .
Thanks,
Mahesh.
So you won't need to me to create a sample for you then?
Hi,
No need to create
Thanks,
Mahesh