how to add a filter that allow user to pick whether include excluded data or not

Question

Hello all,

I am working on the script that make graphs based on a big data table. There are many bad data that I have cleaned by using excluded function. But it would be great if I can set up a filter for users to decide whether they want to include bad data or not. Does anyone know how to achieve it?

Thanks a lot,

Winnie

txnelson · Answer

If you click on the "Clear" button on the filter, it will remove the Excluded row state, and all  of the rows will then show up on the graph.

Mark_Bailey · Answer

The Data Filter controls three row states in the data table. The row states are Selected, HIdden, and Excluded. The filter options are Select, Show, and Include. The Hidden and Excluded row states are independent but some platforms treat them differently.

Are you sure that it is not the Hidden (Show) row state instead of the Exclude row state.

unknown · Answer

Thank you so much for your reply Mark,

I am sorry that I didn't explain my question very clearly. I have made the filter already, but since the data that have been filtered were exclude in the data table, there is no data in the graphs.

I am wondering if there is anyway that allow me include the excluded data in the graph?

Thanks,

Winnie