I have a line chart series that is for accounting.
A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns would show the dollar amounts for separate buckets of money allocations.
What I'm trying to do is have the series chart line start @ 0 (we're trying to mimic another chart that does the same thing).
Right now, the chart line starts at the January amount, say $10,000 for example for the first month data value.
I'm not seeing a property on how to do this...would I need an extra/13th row of 0 values to get the starting point?
Thank you!
A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns would show the dollar amounts for separate buckets of money allocations.
What I'm trying to do is have the series chart line start @ 0 (we're trying to mimic another chart that does the same thing).
Right now, the chart line starts at the January amount, say $10,000 for example for the first month data value.
I'm not seeing a property on how to do this...would I need an extra/13th row of 0 values to get the starting point?
Thank you!