Averaging value if the date is the same

[Agodf007]

I have a monthly report that I would like to run that averages results if they are from the same day. Is this possible?


Collect Result Average
Date
1/2/17 1
1/2/17 3 2
1/3/17 4
1/4/17 1
1/5/17 6
1/5/17 6 6

 

[CJ_London]

use a group by query? group on date, average on result?

 

[Agodf007]

I am not sure if I understand. Could you expand? Thank you.

 

[Minty]

Open the query builder - bring in your table. Press the Epsilon (Totals) symbol in the query builder.
Assuming your Collect date field only has dates and not date/time elements bring that into the fields to output, and select group by in the totals line.

Bring in your results field, and under in the totals line select average. Does that give you what you were after? Video here https://www.youtube.com/watch?v=ehnwAJhnzC0

 

[Agodf007]

I have many fields in my query. The query will only run if group by is located in all other fields too, defeating the "group by" in collect date.

 

[Minty]

Ah - well you didn't tell us about lots of other fields did you

You may want to have a read about sub queries http://allenbrowne.com/subquery-01.html - but this is not really beginner level, so perhaps you should simply do the average as a first saved query then add that back to your other query fields with a suitable join.