I am having trouble with the mapping Zero on a line chart. I have set of data where some of the Dates doesn't has values. So, i have created a date table and related with each other. But, still, I am missing the values showing on the missing months. On the X-axis, it simply skipping the Months where there is no data.
I have already set the X-axis Type to "Categorical".
any help ?
below is the sample data. if you observe, in the Month January and February, there is no Garage Data.
| Year | Month | TRIPS | TICKET_TYPE |
| 2018 | May | 58 | DRIVING |
| 2018 | May | 15 | GARAGE |
| 2018 | June | 98 | DRIVING |
| 2018 | June | 26 | GARAGE |
| 2018 | July | 125 | DRIVING |
| 2018 | July | 40 | GARAGE |
| 2018 | August | 84 | DRIVING |
| 2018 | August | 27 | GARAGE |
| 2018 | September | 100 | DRIVING |
| 2018 | September | 10 | GARAGE |
| 2018 | October | 210 | DRIVING |
| 2018 | October | 3 | GARAGE |
| 2018 | November | 186 | DRIVING |
| 2018 | November | 1 | GARAGE |
| 2018 | December | 10 | DRIVING |
| 2018 | December | 18 | GARAGE |
| 2019 | January | 20 | DRIVING |
| 2019 | February | 62 | DRIVING |
| 2019 | March | 79 | DRIVING |
| 2019 | March | 2 | GARAGE |
| 2019 | April | 32 | DRIVING |
| 2019 | April | 2 | GARAGE |
