Filter on a dashboard with multiple data sets not working for all cards

Reply
Yellow Belt

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??


Accepted Solutions
Major Blue Belt

Re: Filter on a dashboard with multiple data sets not working for all cards

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.

filter1.PNGfilter2.PNG

This should make your filter apply to all the datasets on the card.

Hope this helps.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post


All Replies
Major Blue Belt

Re: Filter on a dashboard with multiple data sets not working for all cards

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.

filter1.PNGfilter2.PNG

This should make your filter apply to all the datasets on the card.

Hope this helps.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Highlighted
Yellow Belt

Re: Filter on a dashboard with multiple data sets not working for all cards

Replying back to my own post Cat Embarassed -->

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!

Yellow Belt

Re: Filter on a dashboard with multiple data sets not working for all cards

Thanks for posting this! I obviously did not see your reply when I responded. Ugh - new to using Dojo!

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!