Looker Line Chart Falls off the cliff for future dates

Shai2
New Member

Hi,

I need to create a line chart comparing past three year performance. However for the current year, because we don’t have data after May, the line just falls off the cliff and looks weird (like our performance has declined). 

0258633d-2559-48bc-9812-fee265f3e24b.png
Looker Chart

Is there a way in Looker to stop the line from going to 0 for days we don’t have any data ? I created the same chart in Excel, and this is what I am looking for

PS - I can’t use bar chart or any other chart format, since the request is to show the data in Line chart format

14eceeb1-3977-464b-88a4-e70a5eff65d3.png
Excel Chart
1 1 567
1 REPLY 1

There’s an option in the settings of a visual to not plot null values

Top Labels in this Space
Top Solution Authors