I have a dataset like this;
| date | weight |
| 2018-09-01 | 82.0 |
| 2018-09-02 | 82.3 |
| 2018-09-03 | 82.1 |
| 2018-09-15 | 82.3 |
| 2018-09-16 | 83.1 |
| 2018-09-29 | 82.3 |
| 2018-09-30 | 82.9 |
The null dates are missing when I create a time series line chart. How can I create a line chart that includes missing dates to accurately show the time series spacing? Ideally, the line would go from date with data to date with data.
Cheers Team!