Filters is not working the insights Dashboard

@nextchamp.saqib
i have dashboards in insights when i drag the filter from the widget ,in the columns it is not showing the column in select list because that i enable to add the filter in the dashboard. Can any one tell how to add the filter in dashboard ??

@nextchamp.saqib

In Frappe Insights,

Filters are not working for the dashboards which are done by using a sql query.

They are working for the dashboards which are done by using a visual query.

Can anyone pls let me know !!

If it isn’t working for you, try this hack: x.com

@michelle Thank you.

1 Like

This didn’t work for me. When i try yo add the native query as a table in another query, it says (pymysql.err.ProgrammingError) (1146, “Table ‘_3c9620726336f372.QRY-33704’ doesn’t exist”)

SOLVED: We have to enable the Query Reusability in settings. It’s disabled by default.