I am trying to create a button which would exclude a certain product which is considered an outlier.
I had originally created a bookmark which excluded the product through the selections panel and then connected the bookmark to the button and this worked fine. The issue then comes when new data is brought in which wasnt available previously. These are now also not showing when using the bookmark. Is there any other way to create an exclude function.
Instead of a direct selecting of values you could apply a search to the (measure) field, like: >0<1000 which could be also included within a bookmark.
Such a condition might be also included within a set analysis which may save the need of a bookmark and an extra button to call it.
Another possibility - especially useful if the condition relates not to field-values else to aggregation results - could be to wrap the expression with range-functions, for example something like this:
