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.

1
1 votes

Comments

  • Kurt
    Kurt Member

    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.