How to skip nulls in rank and window?
I have a dataflow that is joining multiple datasets with information about a set of schools - 29 elementary schools and 3 high schools. One of the data sets is specific to tests scores that only the elementary schools take, so the high school rows are "null."
This dataflow that I am creating aims to generate separate rankings for each of the different categories joined together. In all other cases, the rankings are fine for all 32 schools. In the case of the test scores, the nulls are being counted in the rankings.
I need all 32 rows present in the output dataset, but just don't want those three high school rows with a rank for that specific column.
How can I skip those "nulls" in the ranking?
Thanks!
Answers
-
You could try using a beastmode, something like
case when `SchoolType`='High School' then null else `TestScoreRank` end
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive