Chart Null Behavior Enhancement

Giovanni Farris shared this idea 4 years ago
Completed

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.

Thanks

Giovanni Farris

Principal

Blacklight Solutions

Austin, TX USA

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

e.           giovanni@blacklightsolutions.com

w.           www.blacklightsolutions.com

Capturing Opportunity with Analytics

Comments (2)

photo
0

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.

regards,

David

photo
2

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