Ajouter aux favorisJunaid Liaquat (CVS health /Aetna) a publié du contenu dans ESG Reporting & Disclosure (Question initialement posée par Junaid Liaquat)29 oct. 2024, 19:39Junaid 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 : #AnalyticsAfficher plusAjouter un commentaireRédiger un commentaire...GrasItaliqueSoulignerBarréListe à pucesListe numérotéeAjouter un lienBloc de codeInsérer une imageJoindre des fichiersURL du lienAnnulerEnregistrer0/9000Répondre
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 : #AnalyticsAfficher plus