Skip to main content
Dynamics 365 Community / Forums / Microsoft Dynamics CRM forum / How to calculate Stage...
Microsoft Dynamics CRM forum
Answered

How to calculate Stage durations for Business process flows?

editSubscribe (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!

Categories:
Development / Customization / SDK
Attachments
  • 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,473 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!

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Demystifying Copilot with Sundar Raghavan

Sundar explains how Copilot for Service is meant to function separately...

Business Process Guidance Badges and New…

The Microsoft Success by Design is the framework for implementing Dynamics 365…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,281 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,025 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans