We have applied filters for ".pxCreateDateTime" property for case instances of class "Work-Channel-Interaction-WebChat" as in attached image.
Looking for a confirmation, Current month filter means-> The current calendar month, and Previous Month filter means -> The last calendar month. If this is the understanding then the reports results should not change if we run the report on different days of same month.
But we are noticing the report result changes on everyday. Could anyone please help, if have seen similar issue ?
Hi @Vikas_Agrawal: Is the report definition is executed using same user profile without changing Time zone? If it is with same user without time zone change, it should give same results for previous month. If there is a change in time zone, it is expected because the backend SQL is dependent on the time zone.
If it is still giving different results for each date, better to investigate the data to check if any hard update is done to the data.
Posted: 1 month ago
Posted: 12 Oct 2022 4:00 EDT
Raghuram Jonnadabattaru (RaghuramJ16633460)
Senior Product owner Lead Business Architect Agile