Chart Null Behavior Enhancement

Giovanni Farris shared this idea 4 years ago

I just wanted to submit an enhancement request.

Currently, in a line chart, you have an option to define the behavior of null values.  Currently, those options are Break or Zero.  It would be great if there was a third option (Connect).  Basically, this would draw a straight line between points through null values.  So, given the structure:

Date           | Value

1/1/2017   |  10

2/1/2017   |  null

3/1/2017   |  20

4/1/2017   |  22

The chart would draw a line from the point (1/1/2017, 10) to the point (3/1/2017, 20).

I’m currently trying to work around this using a trend on the field, but there are UI characteristics around it which preclude a reasonable display.


Giovanni Farris


Blacklight Solutions

Austin, TX USA

p.           +1 (512) 795 – 0855 ext 103



Capturing Opportunity with Analytics

Comments (2)


Hi Giovanni,

OK, I'll move this Ticket to an Idea. For future reference you don't have to start everything in Community as a Ticket, you can also choose Idea, Problem or Question, the main difference being that a Ticket is private between you and us.




Hi Giovanni,

There is an option to do this. It is possible to have three options: null, skip and zero; and skip joins the lines.

As such I'm going to mark this case as Completed, but please let me know if you have any questions on this.

Regards, Mike