Drill down to a separate dataset - matched by column?
I am trying to create a card that drills down to another dataset, but matches values based on a specific column in order to show rows for the selected category.
For example, the card categorizes employees based on country (dataset A). When I click on US employees, I want the card to drill only show me US employees BUT using dataset B to do so. Basically, this would require some sort of match by column, but I have no idea how to do it.
P.S. it has to be a different dataset due to PDP settings.
Answers
-
Hi @svetlana
You can use a different dataset in your drill path card however if you wish to have the filter applied to the drill path card your filter field needs to be named the same within the two datasets.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hi Grant, thank you for your reply!
I just renamed both columns in both datasets to be the same (country & employee ID), yet when I try to drill down I get this: "An invalid column was specified in your request (the column does not exist on the dataset)"
Do you have an idea why it's happening?
(I refreshed both pages)
0 -
Does your card display properly when editing your drill path? Do you have any beast modes on your drill path card that would reference a column which no longer exists?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Does your card display properly when editing your drill path? Yes
Do you have any beast modes on your drill path card that would reference a column which no longer exists? No
0 -
@svetlana do you have any filters applied in your top level card on columns that do not exist in your drill path card?
This has tripped me up before - when you drill down all the filters from your top level card are carried through (even though you don't see them explicitly) so if any don't exist on your drill path card dataset, it won't work.
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive