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

darien · September 23, 2020, 5:17pm

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?

Ryan · September 23, 2020, 9:40pm

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)

system · October 18, 2020, 11:30am

system · November 2, 2020, 12:59am

system · November 21, 2020, 2:01pm

system · December 10, 2020, 4:47pm

system · December 30, 2020, 9:18am

system · January 19, 2021, 1:46pm

system · February 8, 2021, 10:13pm

system · March 2, 2021, 2:43am

system · March 23, 2021, 12:34pm

system · April 14, 2021, 2:31am

system · May 5, 2021, 9:32pm

system · May 27, 2021, 10:45pm

system · June 19, 2021, 2:48pm

system · July 12, 2021, 11:00am

system · August 3, 2021, 10:57pm

system · August 27, 2021, 12:25am

system · September 19, 2021, 11:47am

system · October 13, 2021, 3:43am