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
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive