* CRM Analytics 日本 *(旧 Tableau CRM)

Hi guys,  

i need your help.  

In Analytics studio i add a fomula columns with this formula: 

case  

when '

RefOrder.Name

' == "Alessandro Marcioni" && sum(Netto_ADV__c)>= 650000 then 1500 

when '

RefOrder.Name

' == "Antonio Amendola" && sum(Netto_ADV__c) >= 300000 then 1500 

when '

RefOrder.Name

' == "Christian Morico" && sum(Netto_ADV__c) >= 830000 then 1500 

when '

RefOrder.Name

' == "Daniele Tinelli" && sum(Netto_ADV__c) >= 400000 then 2000 

when '

RefOrder.Name

' == "Fulvio Caccialupi" && sum(Netto_ADV__c) >= 520000 then 1500 

when '

RefOrder.Name

' == "Ilaria Bruno" && sum(Netto_ADV__c) >= 560000 then 1500 

when '

RefOrder.Name

' == "Marco Franco Selvi" && sum(Netto_ADV__c) >= 600000 then 1500 

when '

RefOrder.Name

' == "Rosario Loddo" && sum(Netto_ADV__c) >= 580000 then 1500 

when '

RefOrder.Name

' == "Sergio Staiti" && sum(Netto_ADV__c) >= 750000 then 1500 

when '

RefOrder.Name

' == "Walter D'alessandro" && sum(Netto_ADV__c) >= 650000 then 1500 

else 0  

end  

i need to add to this formula a filter how i can do this in a formula column in analytics studio? 

Thanks in advance 

Best 

Hey All ,

I am looking to filter user records to only one specific profile name or licensed by in dataflow filter node with SAQL filter check . Here is the screenshot .

"Something went wrong while executing the filter user node: Invalid Filter Expression=Licensed_By__c : EQ : CEC [error category: USER]: Syntax Error at position [line 1: column 17] after token Unexpected character ':' :: ;censed_By__c : EQ : CEC; (02Kj0000000Kys4EAC_03C7i000001vT5TEAU)"

Please help me out if there is anything i need to change or use other filter expression. 

I am trying to filter case object in CRM analytics Dataflow but for some reason my filter node keep failing . With this error" Something went wrong while executing the date filter node: Invalid Filter Expression=date(‘CreatedDate_year’, ‘CreatedDate_Month’, ‘CreatedDate_Day’) in [“1 year ago”.. “current year”] [error category: USER]: Syntax Error at position [line 1: column 6] after token Unexpected character 'â' :: ;date(‘CreatedDate_; (02K7i000001ZYbaEAG_03C7i000001vMotEAE) "

Please help me out if anyone know where i am getting wrong i need 24 months case date only instead of all time. here is the reference 

SAQL Script for filter node : 

#Analytics