How to drill down with 2 datasets
I wanted to create a drill down in a card. The main chart and drill down chart using 2 different datasets, but both have a field called id. From main chart (a table chart with id in the table), user click the id and drill down to another chart. But nothing come out. Did I miss something?
Thank you.
Olivia
Best Answer
-
If you had it set like this it would appear correct.
Dataset 1:
Id
Name
Date
Dataset 2:
Id
Color
Food
Activity
You should set the top card with dataset 1 however you like. Then when creating the drilldown switch the dataset to Dataset 2. Make sure Id is on the card you're drilling down to (I can't remember if it's required or not but can't hurt). That's it.
The caveat though is that if the user clicks on any of the other bits of information you might get no results back because if on the main card they click on the "Name" "Joe" it will attempt to pass the value of "Joe" to the next card. They have to click on an Id
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Answers
-
If you had it set like this it would appear correct.
Dataset 1:
Id
Name
Date
Dataset 2:
Id
Color
Food
Activity
You should set the top card with dataset 1 however you like. Then when creating the drilldown switch the dataset to Dataset 2. Make sure Id is on the card you're drilling down to (I can't remember if it's required or not but can't hurt). That's it.
The caveat though is that if the user clicks on any of the other bits of information you might get no results back because if on the main card they click on the "Name" "Joe" it will attempt to pass the value of "Joe" to the next card. They have to click on an Id
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 185 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive