# Tracking time spent in stages

**URL:** <https://community.noloco.io/t/tracking-time-spent-in-stages/1211>\
**Category:** Ask for Help\
**Created:** [September 10, 2024, 10:02am UTC](https://community.noloco.io/t/tracking-time-spent-in-stages/1211 "2024-09-10T10:02:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pablo10](https://avatars.discourse-cdn.com/v4/letter/p/779978/32.png) [@Pablo10](https://community.noloco.io/u/Pablo10)\
**Post date:** [September 10, 2024, 10:02am UTC](https://community.noloco.io/t/tracking-time-spent-in-stages/1211/1 "2024-09-10T10:02:52Z")

</div>

Wondering if anyone else has had this use case and if they managed to solve for it.

My app has a collection of deals, and each deal will always be assigned a stage. I want to track time spend (in days) in the current stage and time spent in each subsequent stage as the transaction progresses through the deal lifecycle.

Some reports I would like to run include:

1. how many deals are in stage A August
2. how many deals are in stage B in July vs August vs September
3. how much time is spent in each stage? What are the averages
4. how much time is spent moving from stage A to B and C to D, and what are the averages over time

Thanks!

---

<div class="post-metadata">

**Author:** ![onlymatt](https://avatars.discourse-cdn.com/v4/letter/o/48db29/32.png) [@onlymatt](https://community.noloco.io/u/onlymatt)\
**Post date:** [September 10, 2024, 6:10pm UTC](https://community.noloco.io/t/tracking-time-spent-in-stages/1211/2 "2024-09-10T18:10:01Z")

</div>

I just started on something similar this morning so I haven’t sorted it all out yet. But my thought has been to log the date/time when each stage is started (so one for each stage) and then have calculating fields to find the difference from one stage to the next.

---

<div class="post-metadata">

**Author:** ![Pablo10](https://avatars.discourse-cdn.com/v4/letter/p/779978/32.png) [@Pablo10](https://community.noloco.io/u/Pablo10)\
**Post date:** [September 20, 2024, 10:22am UTC](https://community.noloco.io/t/tracking-time-spent-in-stages/1211/3 "2024-09-20T10:22:42Z")

</div>

Make any headway with this?

---

<div class="post-metadata">

**Author:** ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)\
**Post date:** [September 20, 2024, 10:29am UTC](https://community.noloco.io/t/tracking-time-spent-in-stages/1211/4 "2024-09-20T10:29:40Z")

</div>

Hey @Pablo10 and @onlymatt - while not a direct answer to your question

This post on tracking time in projects might give you some inspiration into how you could automate this

> **[Time Tracking in Projects Using Noloco and Airtable \[How To\] | Noloco Blog](https://noloco.io/blog/time-tracking-in-projects-using-noloco-and-airtable)**
>
> Learn how to efficiently track time with our step-by-step guide on integrating Airtable and Noloco. Learn how to create a tailored Airtable base for logging work and a Noloco app that brings this data to life with custom action buttons and insightful...

I imagine you would need to add a time entry for each stage, linked to each deal

Then you could probably use our [Pivot Tables](https://guides.noloco.io/collections/display/pivot-table) to do the analysis you mention in point 4