Klaas,

If you want to filter your ad hoc data source, you can maybe use the filter component that is in soft launch. You can link that filter component to your query and then you have filters for all your columns. If you then drop a specific column from your query to your filter component, then it will only show a filter UI for that specific column. The filter UI can show a numeric range, free text field with suggestions or a list of checkboxes.

The nice thing about that filter UI is that you don't have to worry about the distinct values in your data set. This will be resolved automatically when you enable the 'filter assistance' in the setting.

In one of the training videos, the filter UI is explained in more detail: Using a filter component and linking it to your graph - DataMiner Dojo