Using graphs in DataWindow objects
432 DataWindow .NET
Examples
This section shows how to specify the data for several different graphs of the
data in the
Printer table in the EAS Demo DB. The table records quarterly unit
sales of three printers by three sales representatives.
Table 15-7: The Printer table in the EAS Demo DB
Graphing total sales
To graph total sales of printers in each quarter, retrieve all the columns into a
DataWindow object and create a graph with the following settings on the Data
page in the Properties view:
•Set Rows to
All
•Set Category to quarter
• Set Value to sum(units for graph)
Leave the Series check box and text box empty.
Rep Quarter Product Units
Simpson Q1 Stellar 12
Jones Q1 Stellar 18
Perez Q1 Stellar 15
Simpson Q1 Cosmic 33
Jones Q1 Cosmic 5
Perez Q1 Cosmic 26
Simpson Q1 Galactic 6
Jones Q1 Galactic 2
Perez Q1 Galactic 1
…………
Simpson Q4 Stellar 30
Jones Q4 Stellar 24
Perez Q4 Stellar 36
Simpson Q4 Cosmic 60
Jones Q4 Cosmic 52
Perez Q4 Cosmic 48
Simpson Q4 Galactic 3
Jones Q4 Galactic 3
Perez Q4 Galactic 6