AVG - time (based on group band condition)
Posted: Fri Dec 25, 2020 11:07 pm
Hi,
I used the DateDiff to get the difference between two time, however, I need to get the average of this time based on the count that I have on group band. for numeric value, if I just divide the numbers by count(), I get the average, but I cannot do it with the time format. please it seems that I need to convert it before to numberic, divide to the Count function (average), and only then to convert to time again. I am not sure if it is this way, but if someone knows how to solve it, I would appreciate it a lot. thx.
I used the DateDiff to get the difference between two time, however, I need to get the average of this time based on the count that I have on group band. for numeric value, if I just divide the numbers by count(), I get the average, but I cannot do it with the time format. please it seems that I need to convert it before to numberic, divide to the Count function (average), and only then to convert to time again. I am not sure if it is this way, but if someone knows how to solve it, I would appreciate it a lot. thx.