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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有