Working with Graphs
Web Tracks gives you the ability to create custom graphs directly within the program. This graphing feature allows you to create graphs from single tables as well as joined tables. Every built-in graph included in Web Tracks was created using this tool.
Deleting a Graph
Select a graph from the list and click Delete. Be aware that you cannot undo the deletion.
Viewing a Graph
Double click on the graph in the graph list.
Designing a Graph
To add a graph to Web Tracks, click the 'Add' command from the graph list. Otherwise, select the graph you wish to design and click the design command (it is not recommended to change the design of the built-in graphs).
This is a descriptive name for the graph. This name must be unique.
This is the category to which the graph will be assigned.
Inventory requires Web Tracks Inventory permissions to view.
Purchasing requires Web Tracks Purchasing permissions to view.
Help Desk requires Web Tracks Help Desk permissions to view.
If you check private the graph will be only available to the creator.
If private is not checked the graph will be viewable and designable by all users who have access to the graph category.
| Single Table Graph
||The above example is of a Single Table Graph. You can select fields from a single table on which to group or calculate
|| Base Table
|| Choose the base table for your graph
| Joined Table Graph
||Selecting a Joined table graph would allow you to group by a field in the primary table and still calculate on a field in the joined table
||If you selected a Joined Table Graph, you then need to select a relationship type
| Join Type
| INNER JOIN
||Include records from the tables where the Join Fields are equal
| LEFT JOIN
||Include all records from the Source Table and only the records in the Join Table where the Joined Fields are equal
| RIGHT JOIN
||Include all records from the Join Table and only records from the Source Table where the Joined Fields are equal
GRAPH FIELDS TAB
From the drop down list of chart types, you can select either Pie, Bar, Line, Point, Pyramid, or Radar. This is the default chart type that is displayed. You can always change the chart type when you're viewing the graph.
This is the field on which your graph will group. The unique values for this field will appear in the legend as well as label points on the graph.
If the field is a numeric field, you will have your choice of seven aggregate functions to perform on the field. If the field is a text field, you can only choose the Count function. In fact, if the field is a text field, it doesn't matter what field you select for the calculated field. The count of the records will be the same as long as it's in the same table.
If the field is a numeric field, you will have your choice of seven aggregate functions to perform on the field. If the field is a text field, you can only choose the Count function.
Note: You will receive an error if you try to calculate on a memo field.
Choose the sort direction for the graphed data.
You may pre filter the graph by adding a filter to the graph definition.
The example listed in the above picture shows how you would create a graph that groups on CPU Type and Counts the number of each CPU Type. This example also filters CPUs on Mhz > 500.
If decided to group on CPU Type and calculate the CPU Speed (Avg), the graph would show the average CPU speed for each of your processors.
Chart Type - Select the type of graph which will be displayed
Note: Depending on the chart's type not all of the options below will be available. The following settings change a the default appearance. These settings can be also be adjusted while viewing the graph.
Graph Appearance - Select a color theme for the graph.
Palette - Select the palette which the graph uses to color points
Label Display - Choose whether to display labels, values, both or neither.
3D? - Select to display the graph in 3D (not available for all chart types)
Label Position - Select the position of the labels rendered on the graph
Show Title? - If checked the Title text will be rendered with the graph.
Show Legend? - If checked the Legend will be rendered with the graph.
Show Criteria? - If checked the graph filter (where clause) will be rendered in the graph's footer.