Hierarchical Relationship Between Columns In Data Sources


Some of the sources I work with have columns with a hiearchical relationship. For example, in the following data source, there are two columns named Master Source and Lead Source:
The Lead Source (Column C) is always a subset of the Master Source (Column . Is there any sort of code that would set up the relationship between these two columns to create an automatic layer of drilldown any time both columns were included in a given card? For example, any card that looked at leads. For example, any card that looked at a given metric by Master Source would automatically have Lead Sources with the same metric that would be nested within that Master Source. At present, of course, one could build two cards and then connect them in a hierarchical relationship, but is there a way to set the relationship of set and subset on the data source level itself?
Best Answer
-
I think this was transferred here and then to ideas:
https://dojo.domo.com/t5/Card-Building/Outlining-Pivoting-Cascading-Hierarchy-Data/m-p/2377#U2377
1
Answers
-
0
Categories
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 479 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 49 Visualize
- 202 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 37 Product Ideas
- 1.1K Ideas Exchange
- 2 Community Forums
- 15 Getting Started
- 2 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 579 日本支部