Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / A field to show number...
Customer experience | Sales, Customer Insights,...
Suggested answer

A field to show number of days a lead has been active

(0) ShareShare
ReportReport
Posted on by Logan W 87

Hi everyone, 

I found there is a timer field on the Lead to Opportunity Sales Process to show how many days a lead has stayed active.  Is there an out-of-box field?  

pastedimage1662018985955v1.png

Basically, I want to calculate and analyze two things

1)  how many days a lead has stayed active

2) once a lead is set to Closed (either qualified or disqualified),  the field just shows me the total number of days from the day the lead is created till the day it is closed. 

Thanks. 

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: A field to show number of days a lead has been active

    Hi Logan W,

    You can fulfil your requirement with the help of two approaches

    1. Approach # 1: As per my understanding, you need two calculated columns here
      1. End Date & Time (When record status equal to Qualified or Disqualified then et value to Now())
      2. Duration in Days (Something similar to End Date & Time - Created On)
    2. Approach # 2: Use timer control

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 8,525 Super User 2024 Season 1 on at
    RE: A field to show number of days a lead has been active

    Hello Logan W,

    Yes we can,

    Please refer below article for it.

    docs.microsoft.com/.../leadtoopportunitysalesprocess

    Thank you,

    Amit Katariya

  • Ray Profile Picture
    Ray 1,505 on at
    RE: A field to show number of days a lead has been active

    Hi,

    I think the time is a out-of-box field "Duration" and this field is in "Lead To Opportunity Sales Process" entity. You may cosider to use it directly.

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