Supressing Fields with Null Values in a Graph

[Former Member]

Post Author: aklys

CA Forum: Charts and Graphs

I'm trying to find out how to supress a field in a graph that has a

null value. So that they are no longer showing the group that has no

value. Does anyone know how to go about achieving this? Reason for

this is that there is not enough room on the graph to display all

fields and it would clean the graph up a great deal.

[Former Member]

Post Author: qcheng

CA Forum: Charts and Graphs

Hi, I don't know if it is possible to supress a null value in a graph or not. But for your reason doing that, we can try the following solution:

Create a new formula field to replace the existing group(X) axis field: if the field has a null value then specify an empty value, otherwise take the original value. You can create another formula field to reorder the group(X) axis such that the empty value is the last value and all other value in the the group(X) axis keep same order. In this case, all null values takes only on position (the last one in right-hand-side) and show nothing.