Is there a way to specify fixed arguments for a 2D line chart?
For example, my data looks like:
| Customer | Month | Sales |
ABC 1 145.56
ABC 2 56.67
ABC 3 13.66
XYZ 1 45.67
NMP 2 67.75
I want my chart, on the X-axis, to always display months 1, 2, 3.
But, if on the data source I filter by customer XYZ, for example, on my x-axis I will only get data for month 1 displayed. Instead, I want to see months 1, 2, 3, but have the values be 0 on the months for which there is no record for that customer. The problem is, I can't easily add records with 0 values to my data.
So is there anyway to specify a fixed range of arguments for the x-axis on the chart?
Thanks