Focal Point
[Closed] - Removing zero values on graph

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/2467006586

February 21, 2017, 09:04 AM
Jasen
[Closed] - Removing zero values on graph
When looking at certain metrics I have segments that will never have a value. These segments show up on the graphs. Is there a way to hide these or do I need to do a separate dimension and or source to exclude these from the graphs?

This message has been edited. Last edited by: Jasen,




WebFocus 8.002
PMF 8.2.3
Windows, all output
February 21, 2017, 09:41 AM
Bob Jude Ferrante
When you say segments that will never have a value, along what dimension are these?

Can you provide an example... are these time periods while display a measure across time, or dimensions that are displaying for a breakout on a measure that will always be zero?

If the former, zero values along the time axis are to be expected and we display those segments to match up with other time series on the dashboard.

If the latter, is there a way during loads to suppress loading expected zeroes in favor of MISSING (Null)? The charts will not display dimensional segments for which the sum of all intersections is Null - that behavior is automatic.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

February 21, 2017, 10:31 AM
Jasen
Didn't realize I cut off the segments. I would agree with the time showing zero values.

You gave me the answer I feared. Zero value vs null value. I will have to take a look and see if I can get these values to be null.


WebFocus 8.002
PMF 8.2.3
Windows, all output