Apply different filter controls to different cards on a dashboard
I'm creating a dashboard with two sections. One shows info on payments that are due in the next 30 days. The other shows info on payments that are overdue. Data for both sections comes from the same data set.
I need my users to be able to choose which "payment states" they want to include in each section, as this can be customized in the transaction system. For example, they may have a statuses called unpaid, under review, payment processing, and paid. Some users may wish to count "payment processing" as paid and not show it anywhere on the dashboard. Others may wish to include those in their list of past-due payments.
I found this post and gave it a try. My dashboard has two filter cards. One is set up to apply only to the "coming due" cards, and the other is set to apply to only the "overdue" cards. At first I thought this did the trick - I can apply different states in the different sections of cards. Unfortunately I've run into two roadblocks:
- I cannot make selections in both filter cards at the same time. Whenever I select something in one, it deselects whatever I had chosen in the other.
- There doesn't seem to be a way to set default values in the checkbox list.
Does anyone know how to solve this?
Pardon the ugly design of the dashboard; I'm in the "function" stage before I get to the "fashion" one! :)
Best Answers
-
You could solve this by creating a beastmode that references the field and use that for the filter card. It would look like this:
Be sure to save the calculation to the dataset. This is an easy quick work around to your problem.
Default selection is not possible with checkbox selector unfortunately. You can only apply default page filters using filter views.If I solved your problem, please select "yes" above
1 -
Correct!
If I solved your problem, please select "yes" above
1
Answers
-
You could solve this by creating a beastmode that references the field and use that for the filter card. It would look like this:
Be sure to save the calculation to the dataset. This is an easy quick work around to your problem.
Default selection is not possible with checkbox selector unfortunately. You can only apply default page filters using filter views.If I solved your problem, please select "yes" above
1 -
Brilliant! Thank you! My users should be able to set up their own default page filters then I think, right?
0 -
Correct!
If I solved your problem, please select "yes" above
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive