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
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive