The requirement is to calculate % conversion of hot and sizzling leads and contacts
to opportunity. The widget should be a percentage that calculates number of "Hot/Sizzling Opportunities" divided by total "All Sizzling/Hot Leads + All Sizzling + Hot Contacts" as a percentage.
Here, I have created a report with Leads, contacts and opportunity contact roles but unable to create a joined report as no common field available in above three reports. Also, there is no tracking of contact conversion in an opportunity.
How to achieve this, any ideas would be appreciated.
#Reports & Dashboards #Salesforce Developer #Salesforce Admin #Agentforce #Trailhead