How to make a chart with Discover
=================================

Discover can produce data which is formatted so that it can be imported
into MS Excel or some other spreadsheet. All of the DISPLAY commands
can be instructed to produce this type of output by using the REPORT command
before entering the DISPLAY command.

For example:

    REPORT CSV filename

This causes output from subsequent DISPLAY commands to be written to
<filename> in "comma separated value" format.

When you are makeing a chart, in most cases the desired chart data will
be a table or matrix.  In this case, you'll want to specify the number of
columns in the matrix.  By default, Discover will handle 10 columns at once.
If there are more, the matrix is broken into multiple parts.  You
can adjust this up to a value of 128

    REPORT CSV filename DOS COLS 128

(The DOS modifier specifies that the file should be written as a DOS
file, not an edit file).  This is advisable if the number of columns is
greater than 10, since edit files have a small line length limitation.

Now you are ready to collect the data for the chart.
Here are a few examples

    DISPLAY GROUP HISTORY $* code.files MATRIX ACTUAL AVERAGE OVER WEEK

    DISPLAY VOLUME SUMMARY

    DISPLAY PARTITION HISTORY db.partfile BY WEEK

(These and other sample charts are shown in the Discover User Guide)

The DIsplay command will tell you that it has written the data to the file
specified in the report command.  To reset the report output enter:
    REPORT STANDARD
(or enter another REPORT CSV command if you want to produce more than
one chart).


At this point, you need to download the data to your PC.  Be careful
to transfer the data in the appropriate mode:

    If the data is in an edit file, use ascii transfer
    If the data was written in DOS format, use binary transfer.

Once the data is on your PC, open the file with Excel (For other
spreadsheet programs, you may need to explicitly import the data).
The first row of the data contains headings. Subsequent rows contain
the dates or numeric values.  The numeric values are expressed in
bytes for file data, or pages for volume and group data.