Filter on a dashboard with multiple data sets not working for all cards
I have a dashboard that has cards from 3 different data sources. When I set up the filters for the page, I think they may have all come from just 1 of the 3 data sources because when i use the filters, only cards from the 1 data set get appropriately filtered. (I did check, and all of the names are the exact same in all 3 data sources)
I did check the card interaction settings and all cards are set to 'Enable interaction filters' to 'Apply to all cards on dashboard' so I really have no idea what else to do.
Anyone know how to get filters to work across multiple data sources??
Best Answer
-
I think I had the same problem as you a while ago. When you click on Add Filter, click on the arrow to the right of the column you are wanting to filter on. Then click on Select All. Here are some screenshots to help you.
This should make your filter apply to all the datasets on the card.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
I think I had the same problem as you a while ago. When you click on Add Filter, click on the arrow to the right of the column you are wanting to filter on. Then click on Select All. Here are some screenshots to help you.
This should make your filter apply to all the datasets on the card.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Replying back to my own post
-->
When I added the filters, I must have either only had one dataset in use or did not see the carrot/dropdown to apply to multiple datasets. When you Add a filter, if the same name of a dimmension is used on multiple datasets sourced on that dashboard, it will give you the option to select as many of those datasets as applicable.
To note, this did highlight for me that one of my filters was called 'contract' in some data sources but 'contract_name' in others. I made a new calculation on the data sources that had 'contract name' so there was another column called contract (the formula was just referencing the `contract_name` field) & applied to the data source. This allowed me to handle the different names from different sources.
Sorry I didn't figure this out before posting but hopefully someone else will find this helpful someday!
0 -
Thanks for posting this! I obviously did not see your reply when I responded. Ugh - new to using Dojo!
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 111 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 782 Beast Mode
- 76 App Studio
- 43 Variables
- 738 Automate
- 186 Apps
- 473 APIs & Domo Developer
- 65 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 138 Manage
- 135 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive