Beast Mode HTML Filter Value
I am trying to accomplish something that I feel should be very easy to do but can't figure out how to do it in Domo. What I am trying to do is add a link, field or button that has a more reader friendly name such as "View More" or "Drill Down Deeper" but the value / filter value is let's say for example, a date.
concat('<div><a href="',fieldName,'">View More</a>') OR concat('<div><button value="',fieldName,'">View More</button></div>')
View More | 2018-07-19 | My Data Report | $5,391
View More | 2018-07-18 | My Data Report | $4,912
View More | 2018-07-17 | My Data Report | $3,453
The "View More" would drill down and add the filter of the date field in the next column (example: if 1st View More is clicked, add " 2018-07-19" as the filter in the drill down.
Thanks!
Jon
Comments
-
I'm not aware of a way to accomplish this to continue in your drill path on your current card. However, you can setup the View More button to apply as a dynamic filter to a new page in Domo. So you can have either one or multiple cards on the new page that all get filtered by whatever the user clicked on.
Here's a link to info on Page Analyzer Links: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mo...
Here's a sample of one:
CONCAT('<a href=''https://domain.domo.com/page/Page#Here?pfilters=['
,'{"column":"ColumnName","dataSourceId":"Enter Datasource ID Here","dataType":"string","operand":"IN","values":["'
,`ColumnName`
,'"]}]'
,'''target="_blank" title="Open in Domo">',`ColumnName`,'</a>'
)This allows you to have a new page open and apply filters based on the "series" being clicked on.
Hope this helps,
ValiantSpur1 -
ValiantSpur
Interesting work around. Thanks for the suggestion. I'll see if that flow could work for us. I do wish the drill path filters were url parameters or the ability to modify drill filters were allowed. I think it would really improve the way users can drill down on table data.
Best,
Jon
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 178 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive