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.
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.
Check this workaround: https://github.com/user-attachments/assets/e9740ee3-5bcd-4b21-87ac-c777fbf39c9c