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.
1 -
@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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 103 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 61 App Studio
- 41 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 400 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive