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.
0 -
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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive