ETL formula vs Beastmode - result discrepancy
I've come across a headscratcher where a formula created within ETL is giving a different result when that exact same formula is created as a beastmode.
In the attached image, the columns "island break" and "test1" are the exact same formula, with the former being created in ETL and the latter as a beastmode in the card.
The duplicate formula is analyzing the hour difference between columns "max end date" and "lag min start", and if the difference in hours is to 24, the formula should return a yes, otherwise, no. You can see it is a a difference of 112 hours. So, the beastmode "test1" is correct and the etl formula "island break" is incorrect.
The "island break" ETL formula column seems to only return the wrong result when:
The Hour difference is between 100-200 (it will say No instead of Yes)
The hour difference is between 0-10 hours (it will say Yes instead of No)
I am wondering if I just need to adjust something in my ETL formula..
((DATEDIFF(`lag min start`,`max end date`))*24)
(HOUR(`lag min start`) - HOUR(`max end date`))
((MINUTE(`lag min start`) - MINUTE(`max end date`))/60)
or `lag min start` is null
then 'yes' else 'no' end
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 895 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部