How to filter out some point selected from a trend chart by clicking a button? Thanks

[giuseppe valenti]

[Gaia Paolini]

A simple button would be using the pre-packaged functionality 'Filter Out Marked Rows' (see image) which you could then undo with a 'Reset All Filters'.

[giuseppe valenti]

Thank you very much,it works very well. But i do not understand why the average of all values do not refresh after filter out these values? Do you know if there is a refresh option?

[Gaia Paolini]

The average, as a line drawn using Lines and Curves, does update when filtering out the marked values. Make sure your visualization reacts to the active filtering scheme (see Data tab in the visualization properties). This should work fine unless you have complicated filtering schemes.

If you are averaging lots of data, it may be that removing a single point (even if it is an outlier) does not affect the average value that much.

[giuseppe valenti]

i do not know,it appears do not update,is there a way to refresh a calculated column(for example average of values in a column) after excluding some rows by filtering out button ?

[Gaia Paolini]

In your original question, I understood you wanted a line on a plot to refresh after marking a button and filtering out the marked rows. However I did not know this involved a calculated column. Calculated columns do not update with filtering.