bar chart from SS data has null entry and malformed date in some entries
This is two separate problems. for those following along at home:
the malformed dates were actually just that. The "numbers" shown in the spreadsheet above were actually much longer but somehow only displaying those digits (shrug).
Ensure your dates are properly formatted. look at the value in the calculation box, or just set them to raw numbers rather than dates.
I'm still not sure where the null data row is coming from. it seems like data studio is ignoring the headers directive in the datasource setup. I got around it by setting a filter to exclude when <parameter> is null