Hello,
I have created a pivot report, which has some time fields in epoch format and i converted those time fields to human readable format using strftime.
But Pivot report time field values are not changing according to their time zone.
Same pivot report showing same time field values in different time zones.
Whereas normal reports are working fine.
How to fix this?
Have you mentioned timezone also in strftime while converting?
no, i should not mention in the query. Same pivot report will be given to two different users with different time zones. What i want is those two different users should see their time field values in their time zones.
But now it is not happening, both users are seeing the same data.