Close Rate Calculation
Hi,
I need to create a formula field that is quite simple.
I need the close rates for my opporunities in Domo (have a salesforce connector) where "Number of Won Opps"/"Number of Transacions". These are number fields that sum up all the opps in each account that were won divided by all won + lost opps.
Could someone help me out here?
Thanks
Comments
-
Do you already have the fields for number of won opps and number of transactions? If not, what fields in your dataset will allow you to tell if something has been won or not? (You can build a CASE WHEN statement to return on wins for the numerator and a straight count for the denominator).
Otherwise all you need to do is when in your card Analyzer, at the bottom below the fields list on the let select 'Add Calculated Field'. From there you can search and double click the Number of Won Opps column add a divide symbol and then double click the number of transactions.
Hopefully this will get you started, let me know if you have any questions,
Valiant
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive