Select case WHEN {{ Month }} = 0 then add_months(current_date(),-13 ) elseWHEN {{ Month }}> month(add_months(current_date(),-1)) then add_months(to_date(concat(year(current_date())-1,'-',{{Month}},'-',1)),-13) else add_months(to_date(conc...
I tried to enable the photon acceleration in ML runtime 9.1 LTS ML (Scala 2.12,Spark 3.1.2) but getting error "selected runtime version does not support photon".I tried for other versions of ML runtime with single and multinode , access mode being s...
My bad, I had missed with the syntax and rewrote the first condition in a alternate manner and it fixed it. Thanks for your time to go through the postThe update code is for your referenceSelect case {{ Month }} WHEN 0 then add_months(current_date(),...
I had gone through the documentation, not explored the query-based dropdown list. However, can the users change the parameter value once the query is refreshed and dashboard is populated? Primarily, I am not sure of how to pass default values for par...