ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Pivot Table - Grand Total calculation Thank you HamzaJ .👍 Pivot Table - Grand Total calculation Hello, Can someone tell me, what is the Default formula used to calculate Grand total in Pivot table widget. Thanks. convert date time field to UTC format Hello, I need some help around converting the date field column. I have a Customer response table coming from Redshift. The date time field is originally stored in UTC format.But when pulling it into Sisense, it is displaying in local timezone. I wanted it to be displayed in the same UTC format as that in the original database. For ex: I have a column response_date, with the date in the backend DB as 2023-08-11 22:09:56.86+00 , but when it comes to Sisense its displaying as : 8/11/2023, 03:09 PM ( which is in local timezone) How to restore to the original UTC time format.
