Filters is not working the insights Dashboard

[amreen]

@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 ??

[Kiranmai]

@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 !!

[michelle]

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

[Kiranmai]

@michelle Thank you.

[kestrel]

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”)

[kestrel]

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

[rajashreechauhan99]

I created two filters on the dashboard with the placeholders “from_date” and “to_date”,I want to display the orders/products dispatched between the “from_date” and “to_date”,my concern here is that how can i access the date entered into the “from_date” and “to_date” filter in order to create a query(visual query/raw query).