Data Studio
1.6K members online now
1.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

bar chart from SS data has null entry and malformed date in some entries

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Screen Shot 2017-07-20 at 9.35.31 AM.pngScreen Shot 2017-07-20 at 9.36.42 AM.pngScreen Shot 2017-07-20 at 9.36.12 AM.pngScreen Shot 2017-07-20 at 9.38.07 AM.png

bar chart from SS data has null entry and malformed date in some entries

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

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