# How to Find Weekly average subscribers count

**URL:** <https://community.amazonquick.com/t/how-to-find-weekly-average-subscribers-count/17750>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [September 6, 2023, 5:00pm UTC](https://community.amazonquick.com/t/how-to-find-weekly-average-subscribers-count/17750 "2023-09-06T17:00:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vishnudev](https://avatars.discourse-cdn.com/v4/letter/v/e9a140/32.png) [@Vishnudev](https://community.amazonquick.com/u/Vishnudev)\
**Post date:** [September 6, 2023, 5:00pm UTC](https://community.amazonquick.com/t/how-to-find-weekly-average-subscribers-count/17750/1 "2023-09-06T17:00:04Z")

</div>

![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/2c1ae386a5671efe16544cc9bd1c5fe7632818f2.png)

How can I find the weekdays avg count of the uid(subscribers)?

---

<div class="post-metadata">

**Author:** ![David\_Wong](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/david_wong/32/15630_2.png) [@David\_Wong](https://community.amazonquick.com/u/David_Wong)\
**Post date:** [September 7, 2023, 5:37pm UTC](https://community.amazonquick.com/t/how-to-find-weekly-average-subscribers-count/17750/3 "2023-09-07T17:37:52Z")

</div>

Hi @Vishnudev,

Can you try this?  
avg(count(UID, [truncDate(“WK”, Date)]))