How ignore a value from a field?

[#1]

Hello everyone,

Imagining i have a field "Countries" and there are 3 values (USA, Canada, Brazil).

I want to create a bar chart, that shows values only from Canada and Brazil, and ignore values from USA.

Is it possible to ignore a value and don´t display data in the chart?

Thanks,

Rodrigo

[sunny_talwar]

Try this in your set analysis:

{<Country = {'Brazil', 'Canada'}>}

[sudeepkm]

in case you want to display values from all except USA then you can use like below.

{<Country = {"*"} - {"USA"} >}

[sasiparupudi1]

or

{<Country-= {'USA'} >}

[satishkurra]

Also please take the below inputs

{<Country-= {'USA'} >}

This will work as below

{<Country= {COuntry - 'USA'} >}

OR

{<Country= -{'USA'} >}

This will work as below

{<Country= {*- 'USA'} >}

Both are correct, it depends on the type of requirement you are suppose to display to the business.

Thanks

Satish