# Analysis - Items Completed During Current Week

**URL:** <https://community.tulip.co/t/analysis-items-completed-during-current-week/2581>\
**Category:** General\
**Created:** [April 23, 2021, 7:25pm UTC](https://community.tulip.co/t/analysis-items-completed-during-current-week/2581 "2021-04-23T19:25:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashchav20](https://avatars.discourse-cdn.com/v4/letter/a/3bc359/32.png) [@ashchav20](https://community.tulip.co/u/ashchav20)\
**Post date:** [April 23, 2021, 7:25pm UTC](https://community.tulip.co/t/analysis-items-completed-during-current-week/2581/1 "2021-04-23T19:25:38Z")

</div>

I’m setting up an analysis for a count of completions during the current week. It’s not counting items that were started the prior week but finished in the current week. How do we still count items that were completed in the current week regardless of when they were started?

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [April 23, 2021, 7:52pm UTC](https://community.tulip.co/t/analysis-items-completed-during-current-week/2581/2 "2021-04-23T19:52:23Z")

</div>

hello @ashchav20, what type of Analysis are you building??

you could use an Expression similar to this one to sort your Completions by Calendar Week: `format_date_tz(date_trunc(@Start Time , 'week'), 'ww', 'UTC')`. you will need to set the Date Range to All Time, and the Analysis will then group the completions by week (only completed this week for this App, which is why you’re seeing 16):

 ![Screen Shot 6](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/2/220f416d13d75459edfb96828f7a5c1db3eb8970.jpeg)  
does this help in what you’re trying to build?? let us know!!

---

<div class="post-metadata">

**Author:** ![ashchav20](https://avatars.discourse-cdn.com/v4/letter/a/3bc359/32.png) [@ashchav20](https://community.tulip.co/u/ashchav20)\
**Post date:** [April 23, 2021, 8:09pm UTC](https://community.tulip.co/t/analysis-items-completed-during-current-week/2581/3 "2021-04-23T20:09:20Z")

</div>

Hey @gio, we’re just trying to create a simple counter that just grabs the date/time of completion during current week. This should do it, thanks again!

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [April 23, 2021, 8:13pm UTC](https://community.tulip.co/t/analysis-items-completed-during-current-week/2581/4 "2021-04-23T20:13:29Z")

</div>


