Gallery

Gallery > Dashboards And InfoGrids

Micro Chart Tool Tip DB Calculated

Demonstrates showing MicroChart tooltips based on SubValues created using the SeriesCollection.Calculate Method.

Download Show C# Code Show VB Code

<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dnc" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<%@ Import Namespace="dotnetCHARTING.Mapping" %>

<script runat="server">

void Page_Load(Object sender, EventArgs e)
{
// Demonstrates showing MicroChart tooltips based on SubValues created using the SeriesCollection.Calculate Method.

// Setup the chart.
Chart.Size = "600x350";
Chart.Title = "<block hAlign='left'>2022 Sales<br>Hover over bars for details";
Chart.ShowDateInTitle = false;
Chart.TempDirectory = "temp";
Chart.Debug = true;
Chart.ChartArea.Line.Color = Color.LightGray;
Chart.ShadingEffectMode = ShadingEffectMode.Four;
Chart.YAxis.FormatString = "Currency";

// Style the title box & legend.
Chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
Chart.TitleBox.Padding = 8;
Chart.TitleBox.Background.ShadingEffectMode = ShadingEffectMode.Background2;
Chart.TitleBox.Background.Color = Color.LightGreen;
Chart.LegendBox.Template = "%Value";
Chart.LegendBox.DefaultEntry.Value = "<block fSize='10'>%YSum";

// Get the data; A series for each person with month elements.
SeriesCollection mySC = getLiveData();

// Transpose so it's a Series for each month with an element for each user.
mySC.Transpose();

// Calculate down to a single series with an element for each user and sub values for each month.
Series s = mySC.Calculate("", Calculation.Sum, ElementValue.YValue);

// Create a tooltip preview showing monthly details for each user element.
Chart.DefaultElement.ToolTip = "<block fStyle='bold'>2022 Sales by %Name<hr>Total: %YValue<hr><Chart:Column values='%SubValueList' width='100' height='50' color='LimeGreen'><row><Chart:ScaleB values='Jan,Dec' width='100'>";

// Hide the subValues.
Chart.DefaultElement.DefaultSubValue.Visible = false;

// Add the random data.
Chart.SeriesCollection.Add(s);

}

SeriesCollection getLiveData()
{
DataEngine de = new DataEngine(ConfigurationManager.AppSettings["DNCConnectionString"]);
de.ChartObject = Chart; // Necessary to view any errors the dataEngine may throw.
de.StartDate = new DateTime(2022, 1, 1, 0, 0, 0);
de.EndDate = new DateTime(2022, 12, 31, 23, 59, 59);
de.SqlStatement = "SELECT OrderDate,Total,Name FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# ORDER BY Name";
de.DateGrouping = TimeInterval.Year;
return de.GetSeries();
}

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<div align="center">
<dnc:Chart ID="Chart" runat="server" />
</div>
</body>
</html>

<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dnc" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<%@ Import Namespace="dotnetCHARTING.Mapping" %>

<script runat="server">

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates showing MicroChart tooltips based on SubValues created using the SeriesCollection.Calculate Method.

' Setup the chart.
Chart.Size = "600x350"
Chart.Title = "<block hAlign='left'>2022 Sales<br>Hover over bars for details"
Chart.ShowDateInTitle = False
Chart.TempDirectory = "temp"
Chart.Debug = True
Chart.ChartArea.Line.Color = Color.LightGray
Chart.ShadingEffectMode = ShadingEffectMode.Four
Chart.YAxis.FormatString = "Currency"

' Style the title box & legend.
Chart.TitleBox.Position = TitleBoxPosition.FullWithLegend
Chart.TitleBox.Padding = 8
Chart.TitleBox.Background.ShadingEffectMode = ShadingEffectMode.Background2
Chart.TitleBox.Background.Color = Color.LightGreen
Chart.LegendBox.Template = "%Value"
Chart.LegendBox.DefaultEntry.Value = "<block fSize='10'>%YSum"

' Get the data; A series for each person with month elements.
Dim mySC As SeriesCollection = getLiveData()

' Transpose so it's a Series for each month with an element for each user.
mySC.Transpose()

' Calculate down to a single series with an element for each user and sub values for each month.
Dim s As Series = mySC.Calculate("", Calculation.Sum, ElementValue.YValue)

' Create a tooltip preview showing monthly details for each user element.
Chart.DefaultElement.ToolTip = "<block fStyle='bold'>2022 Sales by %Name<hr>Total: %YValue<hr><Chart:Column values='%SubValueList' width='100' height='50' color='LimeGreen'><row><Chart:ScaleB values='Jan,Dec' width='100'>"

' Hide the subValues.
Chart.DefaultElement.DefaultSubValue.Visible = False

' Add the random data.
Chart.SeriesCollection.Add(s)

End Sub

Function getLiveData() As SeriesCollection
Dim de As DataEngine = New DataEngine(ConfigurationManager.AppSettings("DNCConnectionString"))
de.ChartObject = Chart ' Necessary to view any errors the dataEngine may throw.
de.StartDate = New DateTime(2022, 1, 1, 0, 0, 0)
de.EndDate = New DateTime(2022, 12, 31, 23, 59, 59)
de.SqlStatement = "SELECT OrderDate,Total,Name FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# ORDER BY Name"
de.DateGrouping = TimeInterval.Year
Return de.GetSeries()
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<div align="center">
<dnc:Chart ID="Chart" runat="server" />
</div>
</body>
</html>

Sample FilenameMicroChartToolTipDBCalculated.aspx
Version5.3
Uses DatabaseYes

JS Charting

Gallery

Micro Chart Tool Tip DB Calculated