This forum is now out of date, for our new forum Click Here
Trellis with null-values how to supress
Question Asked
In a certain situation we have one reports that is used to show two different Trellis-Graphics. In one of then graphics on the Y-ax there are "null"-values.



Is there an option to supress the values that are a result of this "null-value" Y-ax records?

Peter Lasker

Wed Oct 8, 2014 9:52 PM

Answer
Hi Peter,

If I'm understanding this correctly, you have a report that is returning NULLS, actual rows of data, with a value of NULL, though you do not want this to display on the chart?

If this is the case, the only way to stop the chart from displaying this is to stop it from being returning in report.
The chart is based on the report, so if the report has it, so will the chart (if you're including this field in the chart of course).

The alternative is to create 2 reports, 1 table only, 1 chart only (with the NULLS filtered out).

I hope this covers what you're after, and please let me know if I've misunderstood anything.

Thanks,
David

David

Fri Oct 10, 2014 7:58 AM

Answer
Hello David,

The alternative will work for sure.... two reports with filters and 1 graph each....

I also worked out another option : in a calculated field i generate a logical name for the null-values like "others" and the rest will become the "real name". In this way the values are in the graph but can be better understood by the users... and i don't have to develop two reports :-)

Peter Lasker

Fri Oct 10, 2014 5:17 PM

Comment

Glad it works and nice work with the other option!

David

Mon Oct 13, 2014 3:08 PM