Cannot use filter for Native Query

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.

image
image1285×669 36.4 KB

Thanks
Dharma Han Nguye

2

Hi, @hanntd
The dashboard filters aren’t supported with native queries yet. It is planned to be supported though.

3

Thanks @nextchamp.saqib

4

Any timelines on when this will be available?

5

No specific timeline has been established yet. However, I can assist you in creating a specification that you can use to implement the feature on your own.

6

Hi @nextchamp.saqib , Can you please give some idea how can an individual do so?

7

Hi Insights Team,
Not sure that is it similar / different but I need to use script query to fetch data from api. The script 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.