Magic ETL

Magic ETL

beast mode for specific date range

CASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then `2021` else 0 end


getting an error message

Calculation Error : A column in this calculation did not exist.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Answers

  • @kodonnellLT is 2021 a column or is it in single quotes? Try removing any column fields are re-adding them by double clicking from the column list.

    **If this answer solved your problem be sure to like it and accept it as a solution!

  • You're using backticks (`) for your 2021 value and not a single quote to denote it's a string (')

    1. CASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then '2021' else '0' end
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • I'm assuming 2021 is a value and not a column. If so, you put single tics around it, which domo thinks is a column called 2021. Remove the tics around 2021 and it should work. Alternatively, you could rewrite it as this:

    1. CASE WHEN YEAR(DATE(`end_date__c`)) = 2021 THEN 2021 ELSE 0 END


    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Thank you for your help. Now I'm trying to find the results of a survey only for the dates of 2021

    CASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then `answer value` *1' else '0' end

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In