//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(); }