Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
could you please assist where i am going wrong with my formula:
i want to calculate the the average time between 04:00 and 06:00 (bucket)
aggr(avg(if(StartTime>'04:00' and StartTime<'06:00')),StartTime)
Thanks in advance
Kind Regards
Oh may be you have date in your time field... try this
Avg(If(Frac(StartTime) > MakeTime(4) and frac(StartTime) < MakeTime(6), StartTime))
Try this
Time(Avg(If(Frac(StartTime) > MakeTime(4) and frac(StartTime) < MakeTime(6), Frac(StartTime))))
May be you need this?
Avg(If(StartTime > MakeTime(4) and StartTime < MakeTime(6), StartTime))
Avg(If(StartTime > 4 and StartTime < 6, StartTime))
not working, my Startime field info consists of HH:MM:SS
hope this helps
Did you try this?
Avg(If(StartTime > MakeTime(4) and StartTime < MakeTime(6), StartTime))
Oh may be you have date in your time field... try this
Avg(If(Frac(StartTime) > MakeTime(4) and frac(StartTime) < MakeTime(6), StartTime))
@sunny_talwar Excellent!, Thank you so much!
@sunny_talwar Hi,
I have used to above formula, but the avg. time doesn't seem to take the time between the two band 04:00-06:00
Formula used: Time(Avg(If(Frac(StartTime) > MakeTime(4) and frac(StartTime) < MakeTime(6), StartTime)))
Try this
Time(Avg(If(Frac(StartTime) > MakeTime(4) and frac(StartTime) < MakeTime(6), Frac(StartTime))))
@sunny_talwar Thanks!