BM Calculation Aged Incidents
Hi
I am trying to calculate which of my incidents are Aged (over 30 days old from the current date), I have cobbled this together but it can't be working as I change the number and get the same result
CASE WHEN DATEDIFF( CURDATE(),Max(`created_at`)) > 30 THEN 'Aged' ELSE 'Not Aged' end
Could somebody help please?
Kind Regards
Kev
0
Comments
-
Hi @KJRowe6
If you have one incident per row then you don't need to have the MAX in your beast mode - It's always returning the highest date with your incidents.
Try this:
CASE WHEN DATEDIFF( CURDATE(), `created_at`) > 30 THEN 'Aged' ELSE 'Not Aged' end
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 7.4K All Categories
- 13 Getting Started in the Community
- 151 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部