Hi,
I have a data set similar to the following.
day size
01-Oct 1
02-Oct <-- null value
03-Oct 3
Upon setting it in a line chart (day as X-axis; size as measure) the line gets broken on 02-Oct but I'm looking for a way of making it "ignore" the null value and set the line continuous to show the trend of growth (though it stopped growing on day 2, I don't want the line to break or to go down by setting value to 0), that is line links 1 from day 01 to 3 from day 03. Is it even possible? I think I've seen a chart like this a while ago.
Thanks in advance.