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

How can I prevent gaps in a line chart

Started by Blue, 30 Oct 2017 09:43:10 PM

Previous topic - Next topic

Blue

G'day all
CA11.0.5
Redhat Linux
In-built chart (i.e. not RAVE)

I have a line chart (actually a combo chart) that can display multiple measures (each measure is a separate line). The Y axis is dates and the X axis are the KPI values.
Not every date has all the KPI values. The result is breaks in the lines.
Is there are way to make the chart fill the gap when there is no value for a date?

Data scenario.
Date         KPI 1      KPI 2
01/10/17     10         10
02/10/17                  15
03/10/17      7   
04/10/17     12           9
05/10/17     10          12

This will display all the above dates. KPI 1 shows a gap between 01/10 and 03/10 but continuous line from 03 to 04 to 05.  KPI 2 shows a line from 01/10 to 02/10 then a gap then a line from 04/10 to 05/10.

The client doesn't want to see the gaps. Instead can't understand way the chart won't draw the line for KPI 1 between 01/10 and 03/10 and for KPI 2 between 02/10 and 04/10.
I cannot change the data.
I cannot manipulate the data query results to replicate the values to fill the gaps or use a zero value.

Any ideas?




Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand

CognosPaul

add a moving average trendline, set to 1 period.

Take a look at the attached report.