BM Calculation Aged Incidents

KJRowe6
KJRowe6
in Magic ETL

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

Comments

  • GrantSmith
    GrantSmith Coach

    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!**

Categories