Sorting of a column in Pivot table is not preserved after user selected date gets changed

[Xclipse]

Hi @Amit_Raj, please see if the following tips help:

Unable to format dates

Hi, I am using Athena to feed data to Quicksight. In my Athena query, I’m casting an ISO string to a Timestamp like this. cast(from_iso8601_timestamp(dct.start) as timestamp) startdate2 This appears to ‘work’ in that, in the QuickSight DataSet, it shows up as a date. When I display it in a grid though in QuickSight, it only shows the date. This is despite me setting the format to include the time. [image] Can someone please tell me what I’m doing wrong? Thanks Damien PS - I had more …

Supported date formats - Amazon QuickSight