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 · Accepted solution]

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

[Emil_Kos]

Hi @JBartzsch,

Thank you for marking my answer as a solution.

Good luck with your work!

[JBartzsch]

@Emil_Kos This will work perfect, thank you!