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).
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
There’s an option in the settings of a visual to not plot null values