FavoriteJunaid Liaquat (CVS health /Aetna) posted in ESG Reporting & Disclosure (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 MoreWrite 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
