Customer experience | Sales, Customer Insights,...

Track time between stages

(0) Share

Report

Posted on by JW-02052039-0

I'm trying to track time between stages in a pipeline. For Example, how long does it take for a Deal to go from Negotiation > Closed Won. Dynamics seems to track this, but I'm not sure how to access this information so that we can report on it and create charts in PowerBI

In the screenshot below, Application Process Flow is a flow that we've created. It seems to create a table, and the assumption was that a new row would be added for each stage change, but that doesn't seem to be the case.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (0)

Report
Copy link

Link copied!

You need to implement custom logic for this:

Example:
https://nakedcrm.wordpress.com/2017/06/06/how-can-i-work-out-the-time-spent-in-each-stage-of-a-business-process/

https://community.dynamics.com/forums/thread/details/?threadid=02f3ff3a-396d-4bcd-acf5-24de9a9504c7

Thank You,
Pradeep Rai.

Please mark this as VERIFIED. if it helps you to resolve the query

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Partner,

Currently, there is no OOB way to track time between stages.

Generally, we are using another new table to store time data, and workflow/power automate to capture time automatically.

Please refer to the following link for more detailed steps:

https://venkatasubbaraopolisetty.com/2021/04/07/bpf-stages-tracking-time/

https://www.youtube.com/watch?v=m2Yu8xCpOCo

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No

Join the conversation

Community site session details

Track time between stages

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Track time between stages

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates