Date -12 digit integer to a date conversion

[Xclipse]

Hi @Siddhi_21

Please check the following images. They were tested with your dataset, and some values in the DATE2 field from your dataset are incorrect.

Please refer the below pivot table documentation this might be helpful for you.

Super-charged pivot tables in Amazon QuickSight

Amazon QuickSight is a fast and cloud-powered business intelligence (BI) service that makes it easy to create and deliver insights to everyone in your organization without any servers or infrastructure. QuickSight dashboards can also be embedded into applications and portals to deliver insights to external stakeholders. Additionally, with Amazon QuickSight Q, end-users can simply ask questions in natural language to get machine learning (ML)-powered visual responses to their questions. Recentl…

Using pivot tables - Amazon QuickSight