Time Series only showing 3 years

[Josephina]

I build a time series with data from 2017-2021. 

But all time series graphs are only 2017-2019, so 3 years. When I change the start period to 2018, the time series will continue one year longer, but always only 3 years.

How can I get the whole data in the time series graphs?

[BrandonB · Accepted solution]

It looks like you have missing months in your data. There isn't a row for December 2017, January 2018, February 2018, October 2018, etc. Even if a sum for a given month is zero, you still need to have data there. 

[Josephina]

Thank you!
Any ideas, how to create the missing months? I generated a column with all relevant years and a column for the month 1-12. But I don't get these two columns correct together.

[KilianL]

Hi @Josephina ,

check out the TS Filler tool in the Time Series Category, it will fill in missing dates.

Make sure the data type is 'date' before using the TS Filler tool. If this is not the case, you can use the 'DateTime' tool from the Parse category to change it to 'date'.