I'm facing trouble to convert "2020-09-23T15:08:03.259Z" into basic time format in google data studio. Can anyone please help me to figure out this.
Thanks.
I'm facing trouble to convert "2020-09-23T15:08:03.259Z" into basic time format in google data studio. Can anyone please help me to figure out this.
Thanks.
Try PARSE_DATETIME in a custom field:
PARSE_DATETIME("%Y-%m-%dT%H:%M:%E*SZ", DateTimeText), where DateTimeText is your original field with the date time string.
PARSE_DATETIME.