Currency Exchange
As we are a global company, our users are all over the world and some users would like to view the dashboard in their local currency instead of USD.
To accomplish this, during implementation our Domo consultants suggested we duplicate each record with the 122 currencies that we have to calculate the exchange rate.
Then the user will select the filter each time they want to see it in their local currency.
This also caused our dataset to multiply the number of rows by 122.
For example if we have 1 million rows, it will be 122 million.
Comments
-
We also need to keep track of historical exchange rate.
Currently we are uploading the exchange rate on a monthly basis.
For example if December 2024 is USD 1 = EUR 0.95 and in December 2023 it was USD 1 = EUR 0.90, we need to ensure data for that particular month match the correct exchange rate.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
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 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
- 108 Community Announcements
- 4.8K Archive