Hi, the grouping is not working as expected in bar chart when i am using a!recorddata. I am working on PST time. So, any record which is created after 4 PM PST is grouped as the next day. Let's say I have 2 records, one at Feb 12, 3 PM PST and another at Feb 12, 5 PM PST. When I apply a filter for Feb 12, the bar chart actually shows me data of two dates, Feb 12 and Feb 13. The record which is created at 5PM PST is grouped to Feb 13. It is most likely due to the time difference(8 hours) between gmt and pst, as I can clearly observe any record after 4 PM PST is grouped to the next day. Is this behaviour expected? Please suggest me a solution.
Discussion posts and replies are publicly visible