Ability to Filter/Remove Records After Review/Flagged

[thomask]

Hi,

so this could be a little bit complicated.

How can I select multiple lines from a table? (and how could I then DESELECT those items to exclude them form the analysis?)

So, if I understand correctly, the goal is to have a table at the top of your analysis which presents a number of item_id’s. item_id's can be selected (and deselected) from this table - if they are selected then you want those item_id's to be excluded from other visuals in your analysis (or dashboard). This can be achieved as follows: Add a string parameter called selected_item_ids with a comma , as its default value. This parameter will contain a comma separated list of the selected item id'…

darcoli descriped a process to highlight rows in a table. We can use this to populate a parameter with values using the action feature.
In a calculated field you can test with ifelse, if the value of your primary key is in the parameter. If yes you get a 1, else a 0 and then you filter this field on 0. So we get only values, that were not selected as valid.

Now your analyst has to create a bookmark. This way the valid values keep being filtered out the next time the analyst opens the report.

If the analyst selects another value as valid, the bookmark needs to be overwritten.

Was this understandable?