Yes, it is possible to change the Date format from '06-Sept-2024' to '06-09-24' in Insight Report
Follow the steps below:
Go to Insights.
Search for the relevant Insight report.
Click Actions and then click Edit Mode.
Click the Add button and Select Calculation.
Search for the column for which date format needs to be in DD-MM-YY ( i.e. 06-09-24 ).
Click on Three dots and select Format.
Select Format Type as 'Convert to Date'.
Enter Date Format as 'DD-MM-YY'
Change the 'Calculation Text' from 'to_date' to 'to_char'
Add 'Calculation Name' on the left hand side corner to the top.
Click Save.
Click Refresh Data.