True/False Beast Mode Syntax
Hi All,
I am currently working with two joined datasets. Each dataset has a date for each row that gets added. I have outer joined those datasets and am now trying to make sure that the number of date entries are the same in each data set.
I can visually tell that they are the same but I am trying to write a beast mode to confirm via a true/false output.
Because one of the datasets takes a bit longer to trickle all of the information in, I need to make sure the number of rows are the same from the same day of the prior week. (i.e. does September 7th match with September 7th)
Here is the beast mode I have so far.
Any suggestions on how to correct this syntax?
If this helps, feel free to agree, accept or awesome it!
Best Answer
-
Your COUNT doesn't like the condition, you need to return a value for it to count and not a logical expression.
COUNT(CASE WHEN [your condition] THEN 1 END)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Your COUNT doesn't like the condition, you need to return a value for it to count and not a logical expression.
COUNT(CASE WHEN [your condition] THEN 1 END)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Ok, so I changed it to this and that worked. I can go day by day on the calendar filter on the card and get a 1 or a 0 but how to do make the beast mode look at a specific day. In this case, i want to day to be 7 days behind.
If this helps, feel free to agree, accept or awesome it!
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
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive