I am aggregating a metric call “mals,” for 2023 year-to-date, and I found an archived example that I can use. However, I’m getting a syntax error of “The syntax of the calculated field expression is incorrect. Correct the syntax and choose create again” with my query below:
ifelse(dateDiff({date_value},$now(),“YYYY” = 0 AND {date_value}<=$now(), {mals}, 0)
I am new to this but the query part makes sense to me. However I’m not sure what “$” does in this case and “$” isn’t in the QuickSight list of operators. Any help with the query is greatly appreciated.
Thank you for your response. I tried removing the $ before posting, and maybe I am missing something. Even with your suggestions, I can’t get past the syntax error for some reason. Please see screenshot below.