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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive