Hi @Gayathri, based on the error message you are receiving, somewhere you are using an incorrect datatype. My initial thought is that it relates to the datediff calculation since it expects 2 date fields to run the function. Is ‘confirmed_vessel_departure’ a datetime datatype?
Then, with the sum field, I see you’re trying to partition it by 2 fields, we may need to switch to sumOver instead to run this aggregation. It would also be beneficial when debugging this problem with you, if you could create a demo analysis in QuickSight Arena then shared the link for the published dashboard so I can update the calculated fields and test locally.
Let me know if this helps!