AND function is not working in the case statement for a single column values
I'm working with the Domo Governance dataflow, and I wanted to create a card which shows a message based on the successful update.
I have 4 dataflow A,B,C,D. I wanted to see a message 'successful', if all the 4 dataflow has ran successfully today. Else it should should show a message 'Pending'.
Here is my beast mode:
Case when Name = 'A' and Name = 'B' and Name = 'C' and Name = 'D' and
date(last updated time) = Date(Curdate()) and Last Execution state = 'Success' then 'Success'
Now, all the dataflow has ran successfully, but the message is showing as Pending, which is wrong. Is there any issue in my beast mode.
Looking forward for a solution.
Thanks in advance
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board