Beast Mode - Checking data from a different row to generate result
I'd like to create a Beast Mode that takes a value and checks it against another row in my table.
I have a bunch of human annotation data. I want to look at a content_id and then flag if that content_id has been in the QC job. I've made a rough sketch of how the data looks (apologies for the formatting. This is my first time using this message board)
Basically I want to create a Beast Mode that generates the 3rd column (QC Status) that returns a TRUE if any row in the dataset has a content_id that matches AND has been in the QC job.
content_id | job_name | QC Status
001 | original_job | TRUE
002 | original_job | FALSE
001 | QC_ob | TRUE
Ive done some basic case when beast modes in the past, but I cannot figure out how to aggregate this.
Best Answers
-
You would need to do this in Magic ETL. You can use the filter tile to filter where job_name equals QC_Job and then use the join tile to join back to your main dataset and do a left join on content_id with your main dataset being on the left side of the join. The left join will allow all of your main dataset rows to come through while showing a match with the qc_jobs, which you can then label as true.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
You could try a fixed function. Something like this might work:
Case
When sum(count(‘ContentID’)) fixed (by ‘ContentID’) > 1
AND sum(sum(case when ‘JobName’=‘QC_Job’ then 1 else 0 end)) fixed ()
THEN ‘True’ else ‘False’ end
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
You would need to do this in Magic ETL. You can use the filter tile to filter where job_name equals QC_Job and then use the join tile to join back to your main dataset and do a left join on content_id with your main dataset being on the left side of the join. The left join will allow all of your main dataset rows to come through while showing a match with the qc_jobs, which you can then label as true.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
You could try a fixed function. Something like this might work:
Case
When sum(count(‘ContentID’)) fixed (by ‘ContentID’) > 1
AND sum(sum(case when ‘JobName’=‘QC_Job’ then 1 else 0 end)) fixed ()
THEN ‘True’ else ‘False’ end
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Just realized that I never finished my case statement here:
Case When sum(count(‘ContentID’)) fixed (by ‘ContentID’) > 1 AND sum(sum(case when ‘JobName’=‘QC_Job’ then 1 else 0 end)) fixed () >=1 THEN ‘True’ else ‘False’ end
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 691 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive