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
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive