How to creat a filter for currecy change
Hello, I wonder if someone can give me some ideas on how to do this:
I have a coulmn for SpendingCost that contains both Euro or USD. I created 2 new columns one for EURO as SpendEuro, and one for USD as SpendUSD by converting the currency. Now, in my dashboard, I wanted to set up a filter to let user choose currency type, if they choose USD, then all summaries will be based on SpednUSD, if Euro, then SpendEuro. I am not sure ho to set up the filter and let it conencted with both spend columns.
Thank you.
Olivia
Comments
-
I'm not sure of a way to do this via a filter. I have solved a similar problem by building two subpages. One with USD and the other with the same metrics in local currency.
Is there a need for the same user to switch back and forth? Or would most users just want to see one currency. If most users are only interested in viewing either USD or Euro, but not switch between them, I would suggest to different pages, one for each currency.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Hi Olivia,
There's a little trick I have come up with to handle reporting of multiple metrics, which I think will do what you need.
You want to use the 'Collapse Columns' function to make fields for 'Currency' and 'SpendingCost'.
Here's what you fill into each blank:
1. Currency
2. SpendingCost
3. SpendEuro and SpendUSD
4. Euro and USD
If you run into an issue, send a screenshot, and I'll help you out. Once completed sucessfully, you will be able to easily filter on currency. You just may want to have this generate a separate output dataset so that you only use this when it's necessary to toggle between currencies. Otherwise, folks can sum all the values, regardless of currency, and arrive at incorrect values.
PS - If this is a concern, we can also try a cool beast mode to provide an alert in the summary number if a currency is not selected. Alternatively, for table cards, you can include currency as a field to improve clarity.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive