Skip to Content
Former Member
Jan 27, 2009 at 02:23 PM

Filling Missing Dates on Chart Axis in Web Template



I have a chart in a web template that uses a range of data that is organized by date. The data does not contain every date in the range, for example:

Record 1: Jan 1/09

Record 2: Jan 14/09

Record 3 Feb 4/09,

Record 4: etc

The requirement for this chart is to display the dates on the category axis with the axis displaying all the dates between the first and the last date even if records for the dates do not exist. This can be done in a chart in Excel, but I have not found a way to duplicate this in a BW3.5 web template.

Our envionment is BI7 SP13, but we are still using the BW3.5 front end tools.