How to create a proper timeline chart when there are missing rows

Sometimes we have 0 values for some days and we don’t have row in our table in such cases. Is there way to introduce rows with null or 0 values for charting purposes?

Hey Darien!

You can fill in empty days by joining in a CSV file with all the days into your worksheet! For example I have attached a CSV with the past 90 days – If I join this into my worksheet using a Full Outer Join then for all the dates that are not in my original data, I will have an empty row of nulls for every field except for the date.

Last 90 Days.csv (496 Bytes)

1 Like