If you are getting data from a spreadsheet, as it appears, then it may be sending 0 values rather than nulls. But perhaps you are displaying the chart in the spreadsheet itself, rather than fetching it via the visualization api. If so, then you are actually using a different chart library, built-in to sheets, so you will have to ask for help in a forum for sheets.
Another thing you can try is to generate a Table chart, which will show what values are being sent to the chart. On Tue, Nov 19, 2019 at 4:29 PM Torrie Hughes <[email protected]> wrote: > Actually I think the interpolling across NULL is working? > > On Tuesday, November 19, 2019 at 1:28:01 PM UTC-8, Torrie Hughes wrote: >> >> This is what Graph looks like in Excel: >> >> This is what it looks like online: >> >> >> Here is the data that both use: >> >> >> The yellow space is pretty much repeat values from previous which I think >> is what you are talking about on interpolating across null, which would >> explain why those values are dropping to 0. >> >> >> >> On Monday, November 11, 2019 at 10:32:28 AM UTC-8, Daniel LaLiberte wrote: >>> >>> You'll need to post an example of your chart code and data so we can see >>> what you are doing. It should work that using null will end the line, >>> except for the possibility of also using the interpolateNulls option, which >>> would instead connect between non-null values by interpolating across the >>> null. Even so it would not draw zero values. So I am curious to learn how >>> you are seeing zero values, effectively. >>> >>> On Mon, Nov 11, 2019 at 12:19 PM Torrie Hughes <[email protected]> >>> wrote: >>> >>>> Doesn't matter if we use 0 or null it still is dropping to 0. >>>> >>>> On Monday, November 11, 2019 at 8:26:11 AM UTC-8, Torrie Hughes wrote: >>>>> >>>>> We have data that keeps track of 2 things, one will continue and one >>>>> will at some point just stop. I would like to stop it from dropping to 0 >>>>> as >>>>> shown in the picture attached. >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Google Visualization API" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/google-visualization-api/6347489b-fd5a-4f95-9d11-eca2724c49c1%40googlegroups.com >>>> <https://groups.google.com/d/msgid/google-visualization-api/6347489b-fd5a-4f95-9d11-eca2724c49c1%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> >>> >>> -- >>> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >>> [email protected] Cambridge MA >>> >> -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/803eb571-e5d4-4b44-9418-4a4aee85f826%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/803eb571-e5d4-4b44-9418-4a4aee85f826%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJOD-LGB_vGn7R9AQdHtdNEqM%3Dkw9D3DOccyooQq3Az7dQ%40mail.gmail.com.
