Usually, there’s some logic around building a custom expression for the data limiting expression field in Spotfire. When you simply need to exclude certain values you may not want to type out the formula in the custom expression window. This is where Excel tricks come in handy!
Sometimes you’ll get data back that has been tagged. This can be frustrating in Spotfire because at present there is no method for either splitting these apart or delimiting them into a single category.