//Main code for creating chart.
//Note: the argument img is unused because this demo only has 1 chart.
public void createChart(WinChartViewer viewer, string img)
{
// Data for the chart
double[] data0 = { 1700, 3900, 2900, 3800, 4100, 4600, 2900, 4100, 4400,
5700, 5900, 5200, 3700, 3400, 5100, 5600, 5600, 6000, 7000, 7600,
6300, 6700, 7500, 6400, 8800 };
double[] data1 = { 500, 550, 670, 990, 820, 730, 800, 720, 730, 790, 860,
800, 840, 680, 740, 890, 680, 790, 730, 770, 840, 820, 800, 840, 670 }
;
double[] data2 = { 46, 68, 35, 33, 38, 20, 12, 18, 15, 23, 30, 24, 28, 15,
21, 26, 46, 42, 38, 25, 23, 32, 24, 20, 25 };
double[] data3 = { 0.84, 0.82, 0.82, 0.38, 0.25, 0.52, 0.54, 0.52, 0.38,
0.51, 0.46, 0.29, 0.5, 0.55, 0.47, 0.34, 0.52, 0.33,0.21, 0.3, 0.25,
0.15, 0.18, 0.22, 0.14 };
// Labels for the chart
string[] labels = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9",
"10", "11", "12", "13", "14", "15", "16", "17", "18", "19","20",
"21", "22", "23", "24" };
// Create a XYChart object of size 600 x 360 pixels. Use a vertical
// gradient color from sky blue (aaccff) to white (ffffff) as background.
// Set border to grey (888888). Use rounded corners. Enable soft drop
// shadow.
XYChart c = new XYChart(600, 360);
c.setBackground(c.linearGradientColor(0, 0, 0, c.getHeight(), 0xaaccff,
0xffffff), 0x888888);
c.setRoundedFrame();
c.setDropShadow();
// Add a title box to the chart using 15 pts Arial Bold Italic font. Set
// top margin to 16 pixels.
ChartDirector.TextBox title = c.addTitle("Multiple Axes Demonstration",
"Arial Bold Italic", 15);
title.setMargin2(0, 0, 16, 0);
// Set the plotarea at (100, 80) and of size 400 x 230 pixels, with white
// (ffffff) background. Use grey #(aaaaa) dotted lines for both
// horizontal and vertical grid lines.
c.setPlotArea(100, 80, 400, 230, 0xffffff, -1, -1, c.dashLineColor(
0xaaaaaa, Chart.DotLine), -1);
// Add a legend box with the bottom center anchored at (300, 80) (top
// center of the plot area). Use horizontal layout, and 8 points Arial
// Bold font. Set background and border to transparent.
LegendBox legendBox = c.addLegend(300, 80, false, "Arial Bold", 8);
legendBox.setAlignment(Chart.BottomCenter);
legendBox.setBackground(Chart.Transparent, Chart.Transparent);
// Set the labels on the x axis.
c.xAxis().setLabels(labels);
// Display 1 out of 3 labels on the x-axis.
c.xAxis().setLabelStep(3);
// Add a title to the x-axis
c.xAxis().setTitle("Hour of Day");
// Add a title on top of the primary (left) y axis.
c.yAxis().setTitle("Power\n(Watt)").setAlignment(Chart.TopLeft2);
// Set the axis, label and title colors for the primary y axis to red
// (c00000) to match the first data set
c.yAxis().setColors(0xcc0000, 0xcc0000, 0xcc0000);
// Add a title on top of the secondary (right) y axis.
c.yAxis2().setTitle("Load\n(Mbps)").setAlignment(Chart.TopRight2);
// Set the axis, label and title colors for the secondary y axis to green
// (00800000) to match the second data set
c.yAxis2().setColors(0x008000, 0x008000, 0x008000);
// Add the third y-axis at 50 pixels to the left of the plot area
Axis leftAxis = c.addAxis(Chart.Left, 50);
// Add a title on top of the third y axis.
leftAxis.setTitle("Temp\n(C)").setAlignment(Chart.TopLeft2);
// Set the axis, label and title colors for the third y axis to blue
// (0000cc) to match the third data set
leftAxis.setColors(0x0000cc, 0x0000cc, 0x0000cc);
// Add the fouth y-axis at 50 pixels to the right of the plot area
Axis rightAxis = c.addAxis(Chart.Right, 50);
// Add a title on top of the fourth y axis.
rightAxis.setTitle("Error\n(%)").setAlignment(Chart.TopRight2);
// Set the axis, label and title colors for the fourth y axis to purple
// (880088) to match the fourth data set
rightAxis.setColors(0x880088, 0x880088, 0x880088);
// Add a line layer to for the first data set using red (c00000) color,
// with a line width of 2 pixels
LineLayer layer0 = c.addLineLayer(data0, 0xcc0000, "Power");
layer0.setLineWidth(2);
// Add a line layer to for the second data set using green (00c0000)
// color, with a line width of 2 pixels. Bind the layer to the secondary
// y-axis.
LineLayer layer1 = c.addLineLayer(data1, 0x008000, "Load");
layer1.setLineWidth(2);
layer1.setUseYAxis2();
// Add a line layer to for the third data set using blue (0000cc) color,
// with a line width of 2 pixels. Bind the layer to the third y-axis.
LineLayer layer2 = c.addLineLayer(data2, 0x0000cc, "Temperature");
layer2.setLineWidth(2);
layer2.setUseYAxis(leftAxis);
// Add a line layer to for the fourth data set using purple (880088)
// color, with a line width of 2 pixels. Bind the layer to the fourth
// y-axis.
LineLayer layer3 = c.addLineLayer(data3, 0x880088, "Error Rate");
layer3.setLineWidth(2);
layer3.setUseYAxis(rightAxis);
// Output the chart
viewer.Image = c.makeImage();
//include tool tip for the chart
viewer.ImageMap = c.getHTMLImageMap("clickable", "",
"title='{dataSetName} at hour {xLabel} = {value}'");
}
private void generateChart()
{
DataTable[] rawDataTables;
double?yMin = null, yMax = null, y2Min = null, y2Max = null;
imageMapAreas = new StringBuilder();
preSetup();
if (_rcp.Datasources.Length == 0)
{
drawMessage(_noDatasourcesMessage);
finalizeChart();
return;
}
if (_start == _end)
{
drawMessage("There is no data available for selected options.");
finalizeChart();
return;
}
//Get the data from the database
rawDataTables = retrieveData(_rcp.Datasources, _start, _end);
//Set the scale to be measured in days
//Remove the auto-generated labels
_chart.xAxis().setLinearScale(Chart.CTime(_timeZone.ToLocalTime(_start).Date),
Chart.CTime(_timeZone.ToLocalTime(_end).Date.AddDays(1)), null);
addTimestampLabels(_start, _end);
for (int i = 0; i < rawDataTables.Length; i++)
{
DBTable tableHelper;
DateTime[] timestamps;
double[] values;
string[] tooltips;
DisplayDatasourceItem currDataItem;
ConfiguredDatasource currConfiguredDatasource;
Color currLineColor;
string currDataName;
currDataItem = _rcp.Datasources[i];
currConfiguredDatasource = _db.ORManager.Get <ConfiguredDatasource>(currDataItem.ConfiguredDatasourceId);
//If the datasource doesn't exist, don't process it
if (currConfiguredDatasource == null)
{
continue;
}
currDataName = currConfiguredDatasource.Name;
if (rawDataTables[i].ExtendedProperties.Contains("SubTypeId"))
{
DatasourceSubType currSubType;
int subTypeId;
subTypeId = (int)rawDataTables[i].ExtendedProperties["SubTypeId"];
currSubType = _db.ORManager.Get <DatasourceSubType>(subTypeId);
currDataName += " - " + currSubType.Name;
}
tableHelper = new DBTable(rawDataTables[i]);
timestamps = tableHelper.getColAsDateTime(0);
values = tableHelper.getCol(1);
//Adjust the timestamps for the users time zone
for (int j = 0; j < timestamps.Length; j++)
{
timestamps[j] = _timeZone.ToLocalTime(timestamps[j]);
}
//Create an array of strings that represent the tooltips
tooltips = new string[timestamps.Length];
for (int j = 0; j < timestamps.Length; j++)
{
tooltips[j] = getDatapointTooltip(currConfiguredDatasource, timestamps[j], values[j]);
}
//Determine the color to use
if (currDataItem.Color == null)
{
currLineColor = AutoLineColors[i % AutoLineColors.Length];
}
else
{
currLineColor = (Color)currDataItem.Color;
}
bool useYAxis2;
useYAxis2 = (rawDataTables.Length == 2 && i == 1);
//Hide the axis labels when displaying 3 or more data sources
if (rawDataTables.Length > 2)
{
_chart.yAxis().setLabelFormat("");
}
Axis axis = null;
//If there are more than 2 data sources, display them on different axis
if (rawDataTables.Length > 2)
{
axis = _chart.addAxis(Chart.Left, 0);
axis.setLabelFormat("");
}
//Keep a running tab of the overall min and max values
if (rawDataTables.Length <= 2)
{
if (!useYAxis2)
{
double?currYMin, currYMax;
ChartMath.GetDataBounds(values, out currYMin, out currYMax);
if (yMin == null && currYMin != null)
{
yMin = currYMin;
}
else if (currYMin != null)
{
yMin = Math.Min(currYMin.Value, yMin.Value);
}
if (yMax == null && currYMax != null)
{
yMax = currYMax;
}
else if (currYMax != null)
{
yMax = Math.Min(currYMax.Value, yMax.Value);
}
}
else
{
double?currYMin, currYMax;
ChartMath.GetDataBounds(values, out currYMin, out currYMax);
if (y2Min == null && currYMin != null)
{
y2Min = currYMin;
}
else if (currYMin != null)
{
y2Min = Math.Min(currYMin.Value, y2Min.Value);
}
if (y2Max == null && currYMax != null)
{
y2Max = currYMax;
}
else if (currYMax != null)
{
y2Max = Math.Min(currYMax.Value, y2Max.Value);
}
}
}
if (currDataItem.ShowRaw)
{
LineLayer lineLayer;
lineLayer = _chart.addLineLayer2();
lineLayer.addDataSet(values, Chart.CColor(currLineColor), fixLayerNameWidth(currDataName)).setDataSymbol(
Chart.DiamondSymbol, 4, 0xffff80);
lineLayer.setXData(timestamps);
lineLayer.addExtraField(tooltips); //field0
lineLayer.setLineWidth(currDataItem.LineThickness);
if (axis == null)
{
lineLayer.setUseYAxis2(useYAxis2);
}
else
{
lineLayer.setUseYAxis(axis);
}
}
if (currDataItem.ShowTrendLine)
{
TrendLayer tl;
tl =
_chart.addTrendLayer(values, _chart.dashLineColor(Chart.CColor(currLineColor), Chart.DashLine),
fixLayerNameWidth(currConfiguredDatasource.Name + " Trend"));
tl.setLineWidth(currDataItem.LineThickness + 1);
tl.setXData(timestamps);
tl.addExtraField(new string[timestamps.Length]); //field0
if (axis == null)
{
tl.setUseYAxis2(useYAxis2);
}
else
{
tl.setUseYAxis(axis);
}
}
if (currDataItem.ShowLowess)
{
SplineLayer sl;
sl =
_chart.addSplineLayer(new ArrayMath(values).lowess().result(),
_chart.dashLineColor(Chart.CColor(currLineColor), Chart.DashLine),
fixLayerNameWidth(currDataName));
sl.setLineWidth(currDataItem.LineThickness + 1);
sl.setXData(timestamps);
sl.addExtraField(new string[timestamps.Length]); //field0
if (axis == null)
{
sl.setUseYAxis2(useYAxis2);
}
else
{
sl.setUseYAxis(axis);
}
}
}
optimizePlotArea(yMin, yMax, y2Min, y2Max);
//Calculate the scale of the chart based on the plotted data,
//this needs to be called before drawEvents, so the tool tip
//locations for the events can be calculated.
_chart.layout();
drawEvents();
drawLegend();
}