Forum Discussion

PhilB's avatar
PhilB
Kudo Collector
10 years ago
Solved

Omit certain results from data when pulling from the SQL database

Hello,   I imagine this is possible, i just cant seem to figure it out myself. And i know i could apply a filter for this on my visualisations. However this could get tedious quickly.   Reason fo...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    10 years ago

    PhilB Are you ever going to need the info for those users? If not, you could just filter this out by referencing a SQL View where the logic is built in to exclude those users, but return the relevant information you want for the sales table.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

PhilB Are you ever going to need the info for those users? If not, you could just filter this out by referencing a SQL View where the logic is built in to exclude those users, but return the relevant information you want for the sales table.

Habib's avatar
Habib
Continued Contributor
10 years ago

PhilB You can use filter option in Query Editor. This will add a step in your query settings and every time data refresh is executed this step will be executed as well.

 

Please refer to below image for reference.