I have a table like so:
| Year |
ID |
| 2018 |
43636 |
| 2018 |
26436 |
| 2019 |
74573 |
| 2020 |
34264 |
| 2020 |
45673 |
| 2020 |
21355 |
| 2021 |
45727 |
| 2021 |
23456 |
I would like to make a run chart with 'year' as the dimension and count(distinct ID) as the measure. Unfortunately, when the data is filtered in a way that the count for a specific year is 0, the year disappears from the x-axis entirely, rather than displaying 0 or leaving a gap (see attached screenshot). I've tried checking "Include Zero Values" under "data handling" as well as playing with the options under "missing values" in "Appearance". I also tried converting the "year" in the load script to the "first day of the year" (i.e. '2019' becomes '2019-01-01') and then using the autocalendar. This sort of worked, but caused other issues. Does anyone have any advice?
