The string "null" is not the same as a null value. Try removing that string from the cell. Also check that your dates are actually date values and not just strings that look like dates.
Here is your data in a Table, to see what comes through: https://jsfiddle.net/dlaliberte/zjyq9mu1/3/ On Mon, Apr 6, 2020 at 7:14 PM Leif C. Forer <[email protected]> wrote: > I'm trying to draw a Gantt chart and query the Data Table from a Google > Sheet. > > The Gantt chart draws successfully when I hardcode the Data Table in the > Javascript. Here's a working jsfiddle with hardcoded data: > https://jsfiddle.net/lforer/h7Lkxe1r/latest/ > > I can also successfully query the Google Sheet and display selected data > in a table. Here's a working jsfiddle with data queried from the Google > Sheet: https://jsfiddle.net/lforer/mzdvrx0t/latest/ > > Here's the jsfiddle that I thought would work but generates an error: > https://jsfiddle.net/lforer/724os3tg/latest/ > > I suspect the problem may be related to the date and null values in the > Google Sheet. Has anyone encountered this before? Any ideas about how to > fix or debug? > > With thanks, > ~Leif > > -- > 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/db31c6e3-a8eb-4e85-874f-41388e66d7fe%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/db31c6e3-a8eb-4e85-874f-41388e66d7fe%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/CAOtcSJOpu7j%3Dsp%2B77QBuHxoumwnJkvXkqnxF0_02_nMbObyi1Q%40mail.gmail.com.
