Error When Adding Data Source in Frappe Insights After Successful Database Connection

[Prathyusha]

Hi Everyone,

I have successfully connected my database(postgres) to Frappe, but I’m encountering issues when attempting to add a data source in Frappe Insights. Here is a detailed description of what I did:

1. Connected to the database successfully.
2. Tried to add the data source in Frappe Insights.
3. Encountered the following error:

You will need to rewrite or cast the expression.

[Prathyusha]

can anyone help me.