I want not in query in the dashboard filter operator

[Masaru_Asano]

I think this function is useful for realizing aggregation with complex conditions such as subqueries on the dashboard without modifying the schema.

[JoeM]

Hi @Masaru_Asano ,

I'm curious to hear more about what you are looking for here. "Not In" should be available as a dashboard-level operator.

[RADSr]

I suspect ( and agree if it's the case ) that this refers to something like:

==================

WHERE 1 = 1  

AND  <Column> NOT IN ( select <Column> where <interesting condition exists> ) 

===================

Being able to filter on a subquery / result set would be a hugely valuable feature addition! 

[Masaru_Asano]

Yes, there is an "in query" filter that corresponds to a subquery of incorta. Currently, however, it is not possible to specify "not in query", which is the negation of "in query", and it is necessary to define a derived table in the schema that corresponds to the subquery.