For a new implementation, the default configuration of the application will display Performance Chart 1.0. to change this, navigate to System Settings and select "Use Performance Chart 2.0"

System Settings are located at: System => Settings.

For a new implementation of Aeros Live, or for an existing customer that would like to utilize this new feature, you will need to configure the database first. You can get right to adding new fields and charts (we'll explain how to do that below), or you can load the defaults, which are based on the first version of the performance charts.

To default the configurations, execute the stored procedure "spDefaultGroupPerformanceChart". If you would like to overwrite all existing configurations (Do over!!!!) set the @overwrite parameter to "1". This stored procedure will create a default for each Industry type configured for this database.

Once you have all your defaults added, you may want to customize the chart. To do this, you will need to understand the database schema. There are two tables that drive the chart:

The GroupPerformanceChart table determines the list of values you see in the master list tree view. This will always display the latest value from the report data set. It is possible to add values here without needing to specify a chart.

The GroupPerformanceChartLine table is where we will define a chart that we may want to display whenever we click the parent node. The table has been normalized to include anything we'd need to make a line chart with up to four series. At present, we only support line charts.

Here are the specifications for the GroupPerformanceChart table. Should you want to create a line chart, this record will need to exist first. Deleting this record will automatically delete any line chart definitions associated with it (cascade delete).

Here are the specifications for the GroupPerformanceChartLine table.

When developing the new chart, we made sure that date formats were not formatted. Canadian date formats differ from those in the States.

We made sure the new chart used the OS configured date formats.

Control Panel => Region and Language

There are two ways to open the Performance Chart. If you select a flock, you can click the 'Performance" button on the "Live Inventory Options" tab. Also, you can right click the flock to display it's context menu, and select the button from there.

Once you have selected a flock and loaded the form the "Statistics" tab loads. You will notice your values appear in the order you configured them. If you do not see a value here, you will need to check your flock configurations or data. If you specified an incorrect binding, you will not be warned, so check that, too!

Any value that you associated a line chart definition with will have a line chart image next to it. Clicking these nodes will load the chart that you defined. Unlike the master list, if any of the axes bindings are incorrect you will receive a message on the status bar, so pay close attention. If anything looks incorrect, check your flock definitions.

The "Options" tab includes two features:

System Table Set: If you would like to view the chart with standards other than the ones configured for the flock, select that set and click "Reload".

Chart End Date: By default, the chart runs from flock placement to the current date. If you would like to end the chart at a date other than today, update this date and click "Reload".

There are three buttons on the form:

"Reload": Reloads the form for the currently selected flock. This is a great way to update the charts if records for the flock have been updated since you opened the form.

"Print" will open the report for print preview. The chart can be edited, saved or emailed from this preview form.

"Close": Closes the form.

The axes of the series are calculated when the chart loads, to guarantee the ideal scale for each one. You can scroll to zoom in and out of the chart, should you like to drill into a region that might be obscured by closely plotted series.

Hovering over a series will display a tool tip. This will display the actual values plotted by the series. Whether you configured the chart to scale by date or age, both will appear on the tool tip.

The legend and series dashes are automatically determined by the underlying code.

If the chart control detects a standard calculation, it will label the series as a "Standard", and give it a "dot dot dash" line, and a warm line color (red, orange, etc).

If the chart control detects any other calculation, it will create a series for each house for the flock, give it a solid line, and a cold line color (green, blue, etc). each series will be named after it's house code.

Mort. 7,14,21 Day Chart: This is a bar chart that we did not include during this sprint. It has been used in the past for broilers and pullets.

There was a lot of exceptional code that was written to deliver this chart and its values, none of it looked anything like the code used for the other charts.

X-Axis Ages with Dates: The Ages listed across the x-axis of the old charts also included the date. We did not include this for two reasons:

1. If we add a series to compare values to one or more flocks, they will never line up with the current flock, as there is no guarantee the values occur on the same dates.
2. The code that created the dates did not consider Canadian date time formats.