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
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部