Adding Row

JBartzsch

I would like to add an additional row (Vintage) where there is a gap in the year that has a count value of 0, so that the data is chronological without gaps. Ideally, I would like to do this in every instance the gap potentially would occur.

Currently the data reads:

1994 - 2

1996 - 5

1997 - 4

Goal:

1994 - 2

1995 - 0

1996 - 5

1997 - 4

Any solutions would be appreciated!

Emil_Kos

Hi @JBartzsch,

There are probably various ways to approach your problem. I have used to generate rows.

The output:

If you need less/more years you need to change generate rows configuration. Now it starts in 1994 and the max year is 2022

Missing years.yxmd