Filter out selected filter values

Occasionally, we would want to have a chart show everything except the values selected in a filter. For this use case, we recommend using the following SQL in your chart query. 

where
  case
    when '[Filter_name|Default]'= 'Default'
      then 1 = 1
    else not [Column_name=Filter_name]
  end

For the above example: 

  1. If no filter values are selected, then all results are shown
  2. If one or more filter values are selected, then we show everything but those values

Happy Periscoping :)

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like1 Follow
  • 1 Likes
  • 9 mths agoLast active
  • 793Views
  • 1 Following