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

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

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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates