Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to calculate Stage...
Microsoft Dynamics CRM (Archived)

How to calculate Stage durations for Business process flows?

(0) ShareShare
ReportReport
Posted on by SB1982 10

Hello,

I have a requirement from my customer to calculate the duration of sales process stages each user is going through.
eg for all leads qualified as opportunities in 2017: how long were they in Qualify, Discovery, Execution stages etc by owner.

I figured out that achieving this requirement was pretty straight forward to implement in CRM v8.1 or earlier. (below link)
https://community.dynamics.com/crm/b/nakedcrm/archive/2017/06/06/how-can-i-work-out-the-time-spent-in-each-stage-of-a-business-process

However from CRM v8.2 onwards, there has been data model changes in the way the business process works internally...it seems that each BPF spawns a new custom entity..

I was planning to add a custom entity which could track the stage start and end times using a workflow.
However to track the time duration for each stage, I need to know when to trigger my workflow which should ideally happen whenever the BPF starts or stage change happens.

Any ideas, suggestions welcome!

*This post is locked for comments

  • TomSmelser Profile Picture
    TomSmelser 1,570 on at
    RE: How to calculate Stage durations for Business process flows?

    Not sure without seeing details. If workflow running maybe try setting scope to organization.

  • RZP Profile Picture
    RZP 85 on at
    RE: How to calculate Stage durations for Business process flows?

    For some reason the Duration field is always blank.  Any ideas?

  • Suggested answer
    manojd Profile Picture
    manojd 1,397 on at
    RE: How to calculate Stage durations for Business process flows?

    Hi,

    Such information is available in dynamics 365 8.2

    Follow this url

    develop1.net/.../Dynamics-365-Business-Process-Flows.aspx

  • Verified answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: How to calculate Stage durations for Business process flows?

    Hi,

     you might register a real-time workflow on the BPF entity (for example, on the Opportunity Sales Process). If you make it a real-time workflow that is triggered before update and select "Active Stage" from the list of attributes that it'll be triggered on (I believe it's called "Process Changes" in the workflow designer for BPF entities), you'll get stage and duration (there is a field on the BPF entity) for that stage just before that stage is changed to something else. So you can record those values somewhere - on the custom entity, or on the entity for which the process is running.

  • TomSmelser Profile Picture
    TomSmelser 1,570 on at
    RE: How to calculate Stage durations for Business process flows?

    I think you are looking for something like this.

    www.powerobjects.com/.../executing-workflow-upon-change-business-process-flow-stage-dynamics-crm

    Good luck!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans