I have a Tableau dashboard which I used custom sql query as the data source. This data source is showing the companies which have sent vouchers to the employees. Some of the vouchers have been accepted by employees and some of them not.
The companies were facing with an issue in their voucher systems that's why we were seeing lots of fake vouchers in the data.
Data structure:
| id_company | id_voucher | is_accepted | date |
|---|---|---|---|
| 10456 | 2345678 | True | 20-09-2021 |
I need to find a way in Tableau not to show those outlier in the graph and exclude the days in which outlier happened