News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM forum Track time between stages

Microsoft Dynamics CRM forum

Suggested answer

Track time between stages

(0) Share

Report

Report

Posted on by JW-02052039-0

29

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.

Categories:

Administration and Setup

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Track time between stages

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
Suggested answer

Pradeep Rai 5,490 Super User on at

Like (0)

Report

Track time between stages

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,876 Super User

#2

Ludwig Reinhard Microsoft Employee

#3

Martin Dráb 225,425 Super User

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans