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

How to filter 0 or no data out of Time Series Chart ?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Screen Shot 2560-08-02 at 11.25.13 PM.png

How do i filter out the dates or 0% data out of the time series chart? Thank you so much for your guidance!

 

How to filter 0 or no data out of Time Series Chart ?

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Is there actually no data or is there data that lists 0%?

 

If there's actually no data, then go to the style menu. About halfway down, there's a "missing data" section with a drop-down box that defaults to "line to zero." Change this to "line breaks" and your line will start at the first point that has data. 

 

If you have dates that are listed as 0, then it might be worth just changing your date range instead so you don't see those days in your chart. Either that or modify the underlying dataset (if you can) so that the data is null instead of 0.