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.
