3 of 3 people found this helpful
I think you are asking to show the average of hh:mm:ss correct. If that's what you are looking for;
- first convert the hh:mm:ss into seconds using datepart functions
- Since you have to show this as hh:mm:ss again, aggregate using avg function and divide the whole thing by 86400. Number of seconds in a day
- Now right click on the formula , select Default Properties -> select number format
- in the format window, select Custom and give the format as hh:mm:ss
- When you drag this new filed onto the view, you should see the average time as hh:mm:ss
Hope this helps
datepart('hour', [Process Time]) * 3600 +
datepart('minute', [Process Time]) * 60 +
datepart('second', [Process Time])
) / 86400
Thanks karunker , in example I copy paste same date but in my actual data dates are different .
Any idea ?
It might be due to the locale setting on how you see date/time. Let me know if that answers your Q or share your workbook with sample data to see if anything else.
I mean actual data on which I have to do reporting has different dates . to gave example here I just kept same date and just change timings . Is there any way we can take avg of different date and time values ?
So, in that case, what would you like to see when you want to compute the average when you have date. Typically, you want to see average time for jobs, etc. but if you have date, I am trying to see what is your end goal.
This solution saved my day Thanks