Formula Query for Average Duration?
I am trying to use a formula query to calculate the average duration an activity is open. With a little help, I have a query to get the Count and I tried to use that query in a SumValues function to ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe duration is probably in some units like seconds, so there are a lot of them. I suggest that you make a numeric formula field field representing the # of hours such as ToHours([My duration field])
Change your query to query against that pure numeric field and you will know that the result is an hours. If in fact the length of your activity is really in days then you could convert the duration into days instead of hours and add up the number of days.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Change your query to query against that pure numeric field and you will know that the result is an hours. If in fact the length of your activity is really in days then you could convert the duration into days instead of hours and add up the number of days.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Thanks Mark, I tried something like that, but being the geek that I am I divided the result by 86,400,000 (number of milliseconds in a day) and got results that look a little better. I'll try your approach too to see how it turns works.
------------------------------
Paul Peterson
------------------------------
