FavoriteJunaid Liaquat (CVS health /Aetna) posted in CRM Analytics (Tableau CRM) Português (Originally asked by Junaid Liaquat)Oct 29, 2024, 7:39 PMJunaid Liaquathow to use filter node in Dataflow for created date.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 : #AnalyticsShow MoreAdd a commentWrite a comment...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Junaid Liaquathow to use filter node in Dataflow for created date.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 : #AnalyticsShow More
