# AVERAGE over Time

**URL:** <https://forums.knack.com/t/average-over-time/14767>\
**Category:** Get Answers\
**Created:** [August 22, 2023, 1:35am UTC](https://forums.knack.com/t/average-over-time/14767 "2023-08-22T01:35:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Warwick](https://avatars.discourse-cdn.com/v4/letter/w/977dab/32.png) [@Warwick](https://forums.knack.com/u/Warwick)\
**Post date:** [August 22, 2023, 1:35am UTC](https://forums.knack.com/t/average-over-time/14767/1 "2023-08-22T01:35:27Z")

</div>

Hi Knack Friends.

I am trying to use the AVERAGE field to average a connected table’s field values over the last 8weeks.

The AVERAGE filed does not give some of those nice filter features like you can do on tables and pivots where by this would be straight forward.

Does anyone know how to achieve my outcome - potentially with an equation? or any other means.

---

<div class="post-metadata">

**Author:** ![Deanna](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/deanna/32/2284_2.png) [@Deanna](https://forums.knack.com/u/Deanna)\
**Post date:** [August 22, 2023, 5:05pm UTC](https://forums.knack.com/t/average-over-time/14767/2 "2023-08-22T17:05:26Z")

</div>

Couldn’t you use the AVG field type with a formula filter where whatever date field you’re using is during the previous 8 weeks? This would give you a continuous rolling average.

 ![2023-08-22_12-04-14](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/c/c884eea2842954370664015f0da8ff138a45a1f7.jpeg)
