How can we apply drill down functionality between two dashboards in domo?
Answers
-
@jaymin_63 Sadly, interactions don't work when you want to pass filters between cards and pages. I'm not sure if there's an easier way to do this, but I have been able to do this using a DDX Brick card. You can download DDX brick cards from the appstore in Domo, but they do require a little bit of JavaScript. The DDX brick cards are fully functional at setup and have JS that you can customize. I have used the DDX Map Link Navigation before and made the following update to the onClick function already in the code.
Market is the column name that I'm hoping to pass the selected value from the card to the 2nd dashboard. This is done through a pfilter, which I believe is just a page filter, like the ones that apply at the top of dashboards. As long as you have the dataset selected in the card and have the value and name selected in the DDX brick this should work!
function onClick(name) {
var openInNewWindow = true;
// Using name since that is the passed in argument for the function onClick
var link = 'https://optumcare.domo.com/page/773431254?pfilters=[{"column":"Market","dataType":"string","operand":"IN","values":["' + String(name) + '"]}]';
// console.log(name); - returns ['STATE'] - object, have to cast as String()
domo.navigate(link, openInNewWindow);
// domo.navigate('https://www.google.com/search?q=' + value, openInNewWindow);
}
3 -
Solution offered by @jdorsch2 is cool. In case you do not want to use bricks and if you are okay with the user having to click multiple times, I think similar thing could be achieved using variables , beast mode and pfilter combination. It would have its own limitations as to what could be clickable. But if it's a simple table/list of items, it might do the trick
Thanks
'Happy to Help'1
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
- 107 SQL DataFlows
- 648 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 775 Beast Mode
- 75 App Studio
- 43 Variables
- 734 Automate
- 186 Apps
- 471 APIs & Domo Developer
- 63 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 137 Manage
- 134 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