Removing rows with 'Null' values from Chart (Straight Table)

[#1]

Hello,

Is it possible to filter out (i.e. not display) rows which contain a null in a specific column in a Straight Table chart?

I have a situation where I'm getting a duplicate row (with a null in a Value column) for each row of valid data. I've been unsuccessful in identifying the cause so this leads to my question above.

All help and suggestions are appreciated.

G

[prieper]

I would not artificially filter data from being displayed. When they are duplicated then you should cleanse your database. Have you tried a DISTINCT Load of the data, or simply do not load them from the base-system?

Peter

[#3 · Accepted solution]

If you want to keep the null-value-in-row data but just not see it in the chart, you can always try:

Settings for Selected Dimension

Suppress When Value Is Null

[#4]

Thanks for the suggestions!