How to plot null values in a line graph

[jeculbNWRESD]

I am working on an assessment tracker, and I need a way to connect two points that have a null value between them. 

Students have a screener (point 1), and based on the results of the screener, they will be supported and assessed in one area of the screener (green line, point 2), then they will have the whole screener again (point 3). 

Unfortunately, since they aren't assessed on each point at Point 2, I just have dots for point 1 and 3. I need them all to be lines to show overall growth/change, and I can't find a way to "plot null values".

[Lobo-Google]

Hi @jeculbNWRESD , thank you for your post!

I hope I am understanding correctly, but I wonder if you could do something like create a calculated field that manipulates the NULL values into more meaningful values? The IFNULL documentation page provides a pretty good example use case, and how to implement. You could implement something similar to the example, and then use the resulting calculated field to plot the line. 

I understand that might not be the most intuitive way to go about it, but if you'd like to let our team know what kind of functionality you would like to see, that would be really helpful for us! You can file a feature request by following the instructions here: https://www.googlecloudcommunity.com/gc/The-Kitchen-Table/Feature-Requests-How-your-feedback-makes-L...

I hope that is helpful!

[jeculbNWRESD]

Hi, thanks for reaching out, but unfortunately, it's not a 0 value, it's an absent value. In my photo, you can see: the students took a multi-part test at Point 1 , and another at point 2,  but they only took a quiz in one area (point three, orange line), before taking another multi-part test. The line only connects on the area that they did a quiz in, instad of connecting regardless of absent values. So it shows growth from point 1 to point 2, but then there is a blank space in the data, and I just want the points to connect.