Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Hide 0 data points in Line graphs — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Hide 0 data points in Line graphs

Received Response
14
Views
3
Comments
edited Oct 27, 2020 6:34AM in Narrative Reporting 3 comments

Summary

Is it possible to hide data that equals 0 on a line chart?

Content

We have a line chart with a 0 value for the latest month of actuals.  Is it possible to hide this data point?  I can get it to show as a dash or empty in the source grid but it still displays in the chart as I think regardless of what it displays in the grid it still recognises the underlying numbers as a value of 0.  I was thinking potentially using an IFTHEN formula such as "IFTHEN([1]>0,[1],#Missing)" but this syntax doesn't work.  Does anyone know of another solution?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!