If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Continuous Line Chart for Null Values

Started by guileinsighter, 30 Oct 2014 08:09:11 PM

Previous topic - Next topic

guileinsighter

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.