Time Series only showing 3 years

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?

TimeSeries.png

TimeSeries2.png

Date Time

Time Series

Accepted answers

BrandonB

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.

All comments

BrandonB

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.

Year_Month_Columns.png

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'.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703