Close Rate Calculation
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Content
04-19-2025 05:13 AM
Hello, I noticed in the report that the close rate is showing as 60% for a case where I have 14 Total Jobs Booked and 8 Opportunities Booked. Based on logic, the Close Rate should be calculated as:
function calculateCloseRate(closedOpportunities, salesOpportunities) {
if (salesOpportunities === 0) return 0; // Avoid division by zero
return (closedOpportunities / salesOpportunities) * 100;
}
// Example usage:
const totalJobsBooked = 8;
// closed opportunities
const opportunitiesBooked = 14;
// sales opportunities
const closeRate = calculateCloseRate(totalJobsBooked, opportunitiesBooked);
console.log(`Close Rate: ${closeRate.toFixed(2)}%`);
So in this case, that would be:
Close Rate: 57.14%
Anyone, please clarify which columns I should be using to calculate Close Rate on my end, and whether the numerator and denominator may be reversed or based on a different interpretation?
Labels:
- Labels:
-
Associations Reporting
-
Creating Custom Reports
-
Custom Built Dataset Reports
-
Dashboard Settings
-
Dashboard-Custom
-
Dashboard-Upgraded
-
Drill Down Reports
-
Edit Reports
-
Exporting Reports
-
Filtering Reports
-
Modular Dashboard
-
Permissions or Reporting Settings
-
Reports-Legacy
-
Scheduled Reports-Legacy
-
Titan Intelligence
-
Trend Visualization Reports
0 REPLIES 0
