Amount (converted) salesforce field
Could anyone please confirm why Domo does not allow me to select the Amount (converted) field from the Opportunities object in salesforce? It is not even listen as an option when attempting to pull that data by browsing objects and fields. I suspect it might be because it might use a conversion formula not identified/supported by Domo, or maybe there is a way to pull that data? Thanks!
Comments
-
We pull the Opportunity data as one dataset and the ISO Codes and Conversion Rates (from our Salesforce instance) in another data set. We then use a dataflow to recreate the Amount (Converted) field.
I don't know why Salesforce does not expose certain APIs, but this along with Current Stage Age are to fields that we had to manufacture using dataflows in Domo rather than a direct API pull.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
@ST_-Superman-_, Thanks for your reply. This seems to be the way to go. However, the issue now is that this alternative uses the current conversion rate, even for historical data and, thus, skews the data. Any ideas how to go about this? Does salesforce store historical conversion rates?
0 -
Looks like a SOQL query using the convertcurrency() function does the trick!
0 -
@user36203, can you please show how you used that function?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive