RMTrack Custom Reporting allows for two types of line graphs:
LineChart/Simple - A line graph showing a single line.
LineChart/Multi - A multi-line graph showing up 6 lines.
The most common use of line graphs is to show data over time.
The X-Axis values must be automatically convertible to a double precision floating point value. For this example the CreateDate column is a DATETIME type, which can be automatically converted to a double precision floating point value. Virtually any numeric/date value can be automatically converted. Character values, or strings, cannot be automatically converted and query should do an explicit conversion using the SQL functions CAST or CONVERT. The labels for the X axis ticks are automatically calculate
NOTE: The report shown on this page called 'Example - Summary Trends', can be downloaded as part of the Example Reports package.
This report is very similar to the stock report called 'Summary Trends' and is also a good example of a complex report using SQL temporary tables.
