Beast Mode - Parent of Parent type join
I have a data set of project items at multiple levels of a project hierarchy: project > task > sub task. I'm trying to build a sort of rollup card that shows the items based on parent link relationships. i.e.:
- Project Parent = Self
- Task Parent = Project
- Sub Task Parent = Task
I'd like to be able to have a column that shows the top level project ID for a sub task but I don't actually have the project associated to a sub task in my data set. I only have the sub tasks parent task. Is it possible to use beast mode or another solution to get something like:
CASE WHEN `type`='subtask' THEN `subtask_parent.task_parent`
Where `subtask_parent.task_parent` is the subtask's parent's parent (the project)?
Just looking for options.
Comments
-
This almost sounds like a join.
Simple syntax for something like that would be:
SELECT
FROM Dataset AS p
LEFT JOIN
(SELECT *
FROM Dataset
WHERE type = task) AS t
ON t.task_parent = p.project
LEFT JOIN
(SELECT *
FROM Dataset
WHERE type = subtask) AS s
ON s.subtask_parent = t.task_parent
WHERE p.`type` = 'parent'If something like that is possible with your data, that should get you to what you're looking for.
Sincerely,
Valiant
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive