Insights Filters

Business Apps Insights
1

Hi Insights Team,

I need to use native query to write complex sql and join some related tables. The native query run well but when adding to dashboard I cannot use filter. The filter cannot find column name of the query.
Please help me on this issue.

2

Hi,
If you are trying to use the global filter, add all the charts/tables to your dashboard and then add the filter and see if it finds the column name.
If not, you might have to elaborate what the issue is exactly.

3

Check this workaround: https://github.com/user-attachments/assets/e9740ee3-5bcd-4b21-87ac-c777fbf39c9c

4

Filters can be applied for Native Queries using this method:

  1. Enable Query Reusability in Insights settings
  2. Create a native query
  3. Create a visualised query with table as the native query
  4. Add this visual query to dashboard
  5. We can add filters to this visual query that inherits native query

Reference: https://x.com/FrappeInsights/status/1780543019206250977