You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Merge Lead Creation Date & Opportunity Creation Date

Received Response
edited Mar 7, 2024 7:29AM in Reporting and Analytics for HCM 1 comment


We are having a scenario to populate total no of Leads & Opportunity created on Monthly basis. For FY2024, On monthly basis Jan'24, Feb'24 , Mar'24 etc . . It should populate Lead Count and Opportunity count in OTBI. Where as we could able to view either Lead count or Opportunity count only but not both. Since Creation date field is different for both the objects.

Content (please ensure you mask any confidential information):

Lead Reference script :


  WHEN MONTH("Lead"."Lead Creation Date")= 1 THEN '01-Jan' 

  WHEN MONTH("Lead"."Lead Creation Date")= 2 THEN '02-Feb' 

  WHEN MONTH("Lead"."Lead Creation Date")= 3 THEN '03-Mar' 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!