I have a listselector for Months, selection should be multiple and not required. The months in the static are displayed as 1, 2, 3.... One row has one month. What I am trying to do is, when nothing is selected, it should just display all months.
When I use this line in SAQL in CRMA:
q = filter q by 'Account.CreatedDate_Month' in["{{cell(static_Months_1.result, 0, 'Value').asString()}}".."coalesce({{cell(static_Months_1.selection, 0, 'Value'), "12").asString()}}"] ;
I get this error:
Could not parse binding: ...lection, 0, 'Value'), "12").asString() -----------------------^ Expecting '.', got ','
Which makes sense to me. Is there any way I can use coalesce in this Binding?
Or is what I am trying to do here not possible?
Try this:
q = filter q by 'Account.CreatedDate_Month' in ["{{cell(static_Months_1.result, 0, 'Value').asString()}}".."{{coalesce(cell(static_Months_1.selection, 0, 'Value'), '12').asString()}}"];
