Knowledge Drop

Dashboard filter for ${field1} = ${field2}


Userlevel 4

Last tested: Aug 17, 2020
 

If you don't mind editing the model then here is a solution where setting the filter value to "Yes" will apply the filter rules, and setting it to anything else will just not do any filtering:

filter: apply_equality_filter { type: yesno sql: CASE WHEN {% parameter apply_equality_filter %} = true THEN ${field1} = ${field2} ELSE 1=1 END ;;}

 

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply