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?
add a moving average trendline, set to 1 period.
Take a look at the attached report.