Blank values in chart

[ShortyA]

Hi,
I am trying to show a average per day and application via a bar chart. The user wants every date to be shown even if there is no data. I have created a table with every date in and linked via a left outer join to my data table. This doesn't seem to have solved the problem.

Does anyone have any advice ?

I am on CR9 Prof under W2k connecting to SQL Server.
Thanks - ShortyA

 

[lbass]

Did you then use the date from your NEW table in the chart? You should have...

-LB

 

[BobSuruncle]

In CR9, there is a new type of chart called the "Numeric Axis" chart. Select this and then choose the chart button that's in the bottom left of the 6 buttons that are shown.
This will allow you to have a chart that leaves spaces for dates that do not exist.
On the Data tab of the Chart Expert, use the Advanced chart, and choose your date field for the "On Change Of".
With the Date field highlighted in the "On Change Of" box, click on the "Order" button and choose "for each day" in the drop down.
After the chart is generated in the Preview window, right-click on it and choose "Chart Options - Grid" from the shortcut menu.
Click on the "Group Axis" tab in the lower left side of the dialog box.
From the Tabs at the top, click the "Scales" tab.
Turn of the checkboxes for Base Unit, Major Unit and Minor Unit. Ensure that Base Unit is Days and both Major and Minor Units are set to 1 Day.
This should get you close.

HTH



Bob Suruncle

 

[rnd]

Bob,
That is a very valuable tip. But unfortunately the changes won't stay. They automatically roll back to the default values. Is this a bug or am I missing something?
I am using CR 9.2 with SQL2K. I followed all the steps listed.
Thanks.