Aggiungi ai preferitiJunaid Liaquat (CVS health /Aetna) ha postato in ESG Reporting & Disclosure (Domanda originariamente posta da Junaid Liaquat)29 ott 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 : #AnalyticsMostra altroAggiungi un commentoScrivi un commento...GrassettoCorsivoSottolineaBarratoElenco puntatoElenco numeratoAggiungi linkBlocco codiceInserisci immagineAllega fileURL del linkAnnullaSalva0/9000Rispondi
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 : #AnalyticsMostra altro