Users have the ability to change the performance chart metrics and configure what can be seen on the charts. User must have access to the database. User should be experienced with SQL as this is an advanced task. Contact Support or Professional Services for assistance.

Overview

This functionality is available in Aeros LIVE 1.43.7.0 and above.

The Aeros LIVE application includes a charting feature for flock information. The values and charts in this feature are hard-coded, and cannot be customized. All of the information in the feature by default is expressed in imperial units of measure (pounds, etc).

We need charts for metric units of measure, or that display data more pertinent to their concerns.

Implementation

Configuring the Main Form to Use Performance Chart 2.0

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.

Loading and Configuring

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.

use AeLive_XXX_System
exec spDefaultGroupPerformanceChart
@overwrite = 0

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).

Column	Req	Description
GroupPerformanceChartID	integer	Yes	The unique identifier for this record. It is automatically generated, and cannot be changed.
IndustryTypeID	integer	Yes	Charts are configured by industry type. All flocks of one industry type will see this value.
SortOrder	decimal	Yes	The order you would like these values to appear in the master list.
FieldName	string	Yes	The field description
ValueBind	string	No	The House Data Set calculation that you would like to see appear on the list.
ValueFormat	string	No	The standard or custom string format that you would like to display the value as.
ParentID	integer	No	If you want to nest this value inder another node, specify that node's "GroupPerformanceChartID" here.
TempID	integer	No	Do not use this field. It is used for loading the defaults.

Here are the specifications for the GroupPerformanceChartLine table.

Column	Req	Description
GroupPerformanceChartLineID	integer	Yes	The unique identifier for this record. It is automatically generated, and cannot be changed.
GroupPerformanceChartID	integer	Yes	The tree list record this chart belongs to.
IsDaily	bit	Yes	False = values are displayed at weekly granularity. True = values are displayed at daily granularity.
Is14Day	bit	Yes	False = If daily, all values are displayed. True = If daily, the last 14 days are displayed.
PlotZeroes	bit	Yes	False = Zero value series skipped on the chart. True = Zero value series plotted on the chart.
ChartTitle	string	Yes	The title of the chart.
AxisXTitle	string	Yes	The title of the x-axis.
AxisYTitle	string	Yes	The title of the y-axis.
AxisXBind	string	Yes	The House data set calculation that defines the x-axis.
Series1Bind	string	Yes	The House data set calculation that defines the first series/line.
Series2Bind	string	No	The House data set calculation that defines the second series/line.
Series3Bind	string	No	The House data set calculation that defines the third series/line.
Series4Bind	string	No	The House data set calculation that defines the final series/line.
Series1IsPercent	bit	No	True = This value is a percent and should ne multiplied by "100" before it is plotted.
Series2IsPercent	bit	No	True = This value is a percent and should ne multiplied by "100" before it is plotted.
Series3IsPercent	bit	No	True = This value is a percent and should ne multiplied by "100" before it is plotted.
Series4IsPercent	bit	No	True = This value is a percent and should ne multiplied by "100" before it is plotted.

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

Navigating to the Performance Chart

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.

Using the Performance Chart

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.

Performance Chart 2.0: What is Different?

Here is a list of features that were omitted from this version of the chart:

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:

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.
The code that created the dates did not consider Canadian date time formats.

"Estimated" Chart Values: The previous version of the performance chart had code written that would merge or replace missing data with data from the flocks standard. The user would be informed that the number was estimated by seeing a red conditional format for the current value, and prompts on the chart itself.

While this made for nice-looking charts, and compensates for latent or missing data entry, it made it very difficult to compare the charts to reports, that did not have this function. Since we are leveraging the report calculations to display the chart series, this logic is better served there.

Convert Standard Chart to Metric script

Change to 2.0 and run stored procedure, then run the attached script

Browser not supported