Forum Discussion

JosephGomez's avatar
JosephGomez
Qrew Member
4 years ago

Feature Request : AverageValues Formula Query function similar to SumValues for use in Formula Queries

I'm interested in an AverageValues() function similar to SumValues() for use with GetRecords() where the value type of the field is 'Time of Day'. Since there is an Average function that accepts Time ...
formula queries
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Well, under the motto of don't let the things that you cannot do stop you from doing the things that you can, I offer the suggestion.
You can use a formula to convert the time of day field to the number of hours past midnight, using a formula numeric field.
Then you can use a formula query to get a total of those values, and also use a formula query to get a count of those values, and then divide one by the other to get your average.

Once you have that you can turn it back to a time of day using a formula.


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • JosephGomez's avatar
    JosephGomez
    Qrew Member
    4 years ago
    Thanks, Mark. I managed to implement this using a formula field, then in summary reports via summary formula for avg, then converted back to ToD value. Appreciate it.

    ------------------------------
    Joseph Gomez
    ------------------------------