Remove data from graph that contains certain text Spotfire

Question

I hope you can help I have a graph see Pic 1. The problem I am facing is that members of my team have created Professional names with the word 'Dummy' in it to test some scenarios

But for the purpose of actual reporting I would like to remove any Professional Name that contains the word 'Dummy' in it.

Is there a way to easily remove the 'Dummy' data from my Bar chart?

Pic 1

Answer 1

@Philip Connell- You can use the below expression in 'limit data by expression' in properties section of your visualization. This ignores rows containing 'DUMMY' word in NAME Column.

not([Name] ~= "DUMMY")

Here is the test output: