Using pfilters with more than one value
Hi, we have this dashboard with several card filters and we want to click in one "button" that would open the same dashboard with all the filters applied.
We know that this is able to do it easily by creating a BeastMode with pfilters as shown here @MarkSnodgrass video.
and in theHowever, we are not able to find a way to pass the filters applied when we have more than one value selected for each column. For instance, I have a column "state" with 'New York' and 'South Carolina' selected, but the pfilter BeastMode only passes one of the values (e.g. 'New York') to the other dashboard.
Original Dashboard:
Dashboard opened with pfilter:
We know that this may happen because we are limiting the table to 1 row. But that is what we want, to click in one "button" and pass all the values applied to the filter.
We believe that we would need to built the values component of the pfilters URL dynamically, probably using some Bricks. Any thoughts on this?
Best Answer
-
If you review the screenshot I included, you will see there are operands included. So you can create the anchor reference to say things like where value in (X, Y, Z), or where value = X or value = Y. The problem to solve is how to gather the responses. I don't use multi-select so I haven't needed that. But here's an AI suggestion for how to gather selected values.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
You can use the IN operand and give it a list of values you want to include in your filter. There's an example of this on the Domo developer website:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I create a "link" using beast mode using a formula like shown below. First I get out notepad and write out the anchor reference string as if it were written on a web page.
<a href="destination_url">What gets clicked</a>
Then write that all out as if I were passing multiple parameters in a method of something like this….
destination_url?param1=something¶m2=somethingelse
Then I substitute fake values such as underscore X underscore. And I pass that over to an online html encoder. When it comes back I get all the encoded crap you see. Then I paste my real variables back in and use it in Domo.
The link I show below in my redacted screenshot, opens in a new page. Remove the target blank code to change the URL without opening in a new tab. The second redacted value in my screenshot is the unique value of your dashboard….seen in the URL line when looking at it.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
I create a "link" using beast mode using a formula like shown below. First I get out notepad and write out the anchor reference string as if it were written on a web page.
<a href="destination_url">What gets clicked</a>
Then write that all out as if I were passing multiple parameters in a method of something like this….
destination_url?param1=something¶m2=somethingelse
Then I substitute fake values such as underscore X underscore. And I pass that over to an online html encoder. When it comes back I get all the encoded crap you see. Then I paste my real variables back in and use it in Domo.
The link I show below in my redacted screenshot, opens in a new page. Remove the target blank code to change the URL without opening in a new tab. The second redacted value in my screenshot is the unique value of your dashboard….seen when you view it i** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
I create a "link" using beast mode using a formula. First I get out notepad and write out the anchor reference string as if it were written on a web page.
Then write that all out as if I were passing multiple parameters in a method of something like this….
destination_url?param1=something¶m2=somethingelse
Then I substitute fake values such as underscore X underscore. And I pass that over to an online html encoder. When it comes back I get all the encoded crap you see. Then I paste my real variables back in and use it in Domo.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@GrantSmith , @ArborRose thanks for the replies.
I may not have been fully clear so I have edited the question with images. We have two values selected for the same column\filter and we need to open the dashboard with all those values that are selected. But it only passes one of the values.
0 -
If you review the screenshot I included, you will see there are operands included. So you can create the anchor reference to say things like where value in (X, Y, Z), or where value = X or value = Y. The problem to solve is how to gather the responses. I don't use multi-select so I haven't needed that. But here's an AI suggestion for how to gather selected values.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive