Measure/ Field Calculation for 'Daily Average'

[mjkelesh]

Hi there! I am new to looker and was wondering the easiest way (or calculated field formula convention) to turn a measure count into an average. In my example, there is a field that shows daily volumes against a day/date measure but sums over a month or expanded period. How can I use an average function to show a daily average over a monthly timeframe?

[Quinn_Wildman]

Here’s a simple example of a measure which does an average:

measure: my_avereage {
type:average
sql: ${some_field}
}