JS Axis Marker Holidays
Demonstrates holiday calendar pattern markers showing correlation with hotel traffic.
<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dnc" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<script runat="server">
void Page_Load(Object sender,EventArgs e)
{
// This sample demonstrates holiday calendar pattern markers showing correlation with hotel traffic.
Chart.Type = ChartType.Combo;
Chart.DefaultSeries.Type = SeriesType.Line;
Chart.DefaultSeries.DefaultElement.Marker.Visible = false;
Chart.Width = 875;
Chart.Height = 480;
Chart.TempDirectory = "temp";
Chart.Debug = false;
Chart.TitleBox.Label.Text = "Hotel Seasonality in Santa Monica";
Chart.TitleBox.Label.Font = new Font("Tahoma", 9, FontStyle.Bold);
Chart.TitleBox.ClearColors();
Chart.ShowDateInTitle = false;
Chart.YAxis.Label.Text = "Revenue per available room per day";
Chart.DefaultElement.ToolTip = "<b>%xValue</b><br>Revenue per available room per day: {%Value:c0}";
Chart.LegendBox.Visible = false;
//JS settings
Chart.JS.Enabled = true;
Chart.JS.Settings.Add("defaultSeries_states_hover_line_width", "1");
DataEngine de = new DataEngine();
de.ChartObject = Chart; // Necessary to view any errors the dataEngine may throw.
de.Data = "./../../data/resources/hotelsSeasonality_2017.csv";
de.DataFields = "xdatetime=date,yAxis=total";//cvs must have header: date,total
SeriesCollection sc = de.GetSeries();
Chart.SeriesCollection.Add(sc);
Chart.XAxis.Scale = Scale.Time;
Chart.XAxis.TimeInterval = TimeInterval.Month;
Chart.XAxis.Label.Text = "Pickup Date";
//Set markers for US holidays
AxisMarker am1 = new AxisMarker("Christmas and New Year",new Background(Color.LightBlue),new DateTime(2017, 12, 14),new DateTime(2017, 12, 31));
Chart.XAxis.Markers.Add(am1);
AxisMarker am2 = new AxisMarker("Martin Luther King Jr. Day",new Background(Color.LightBlue),new DateTime(2017, 1, 14),new DateTime(2017, 1, 16));
Chart.XAxis.Markers.Add(am2);
AxisMarker am3 = new AxisMarker("Presidents Day",new Background(Color.LightBlue),new DateTime(2017, 2, 18),new DateTime(2017, 2, 20));
Chart.XAxis.Markers.Add(am3);
AxisMarker am4 = new AxisMarker("Memorial Day",new Background(Color.LightBlue),new DateTime(2017, 5, 27),new DateTime(2017, 5, 29));
Chart.XAxis.Markers.Add(am4);
AxisMarker am5 = new AxisMarker("Independence Day",new Background(Color.LightBlue),new DateTime(2017, 7, 3),new DateTime(2017,7, 5));
Chart.XAxis.Markers.Add(am5);
AxisMarker am6 = new AxisMarker("Labor Day",new Background(Color.LightBlue),new DateTime(2017, 9, 2),new DateTime(2017, 9, 4));
Chart.XAxis.Markers.Add(am6);
AxisMarker am7 = new AxisMarker("Columbus Day",new Background(Color.LightBlue),new DateTime(2017, 10, 7),new DateTime(2017, 10, 9));
Chart.XAxis.Markers.Add(am7);
AxisMarker am8 = new AxisMarker("Thanksgiving",new Background(Color.LightBlue),new DateTime(2017, 11, 21),new DateTime(2017, 11, 23));
Chart.XAxis.Markers.Add(am8);
AxisMarker am9 = new AxisMarker("Veterans Day",new Background(Color.LightBlue),new DateTime(2017, 11, 10),new DateTime(2017, 11, 12));
Chart.XAxis.Markers.Add(am9);
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<dnc:Chart ID="Chart" runat="server" style="max-width:900px;margin:0px auto;"/>
</body>
</html>
<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dnc" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' This sample demonstrates holiday calendar pattern markers showing correlation with hotel traffic.
Chart.Type = ChartType.Combo
Chart.DefaultSeries.Type = SeriesType.Line
Chart.DefaultSeries.DefaultElement.Marker.Visible = False
Chart.Width = 875
Chart.Height = 480
Chart.TempDirectory = "temp"
Chart.Debug = False
Chart.TitleBox.Label.Text = "Hotel Seasonality in Santa Monica"
Chart.TitleBox.Label.Font = New Font("Tahoma", 9, FontStyle.Bold)
Chart.TitleBox.ClearColors()
Chart.ShowDateInTitle = False
Chart.YAxis.Label.Text = "Revenue per available room per day"
Chart.DefaultElement.ToolTip = "<b>%xValue</b><br>Revenue per available room per day: {%Value:c0}"
Chart.LegendBox.Visible = False
'JS settings
Chart.JS.Enabled = True
Chart.JS.Settings.Add("defaultSeries_states_hover_line_width", "1")
Dim de As DataEngine = New DataEngine()
de.ChartObject = Chart ' Necessary to view any errors the dataEngine may throw.
de.Data = "./../../data/resources/hotelsSeasonality_2017.csv"
de.DataFields = "xdatetime=date,yAxis=total" 'cvs must have header: date,total
Dim sc As SeriesCollection = de.GetSeries()
Chart.SeriesCollection.Add(sc)
Chart.XAxis.Scale = Scale.Time
Chart.XAxis.TimeInterval = TimeInterval.Month
Chart.XAxis.Label.Text = "Pickup Date"
'Set markers for US holidays
Dim am1 As AxisMarker = New AxisMarker("Christmas and New Year",New Background(Color.LightBlue),New DateTime(2017, 12, 14),New DateTime(2017, 12, 31))
Chart.XAxis.Markers.Add(am1)
Dim am2 As AxisMarker = New AxisMarker("Martin Luther King Jr. Day",New Background(Color.LightBlue),New DateTime(2017, 1, 14),New DateTime(2017, 1, 16))
Chart.XAxis.Markers.Add(am2)
Dim am3 As AxisMarker = New AxisMarker("Presidents Day",New Background(Color.LightBlue),New DateTime(2017, 2, 18),New DateTime(2017, 2, 20))
Chart.XAxis.Markers.Add(am3)
Dim am4 As AxisMarker = New AxisMarker("Memorial Day",New Background(Color.LightBlue),New DateTime(2017, 5, 27),New DateTime(2017, 5, 29))
Chart.XAxis.Markers.Add(am4)
Dim am5 As AxisMarker = New AxisMarker("Independence Day",New Background(Color.LightBlue),New DateTime(2017, 7, 3),New DateTime(2017,7, 5))
Chart.XAxis.Markers.Add(am5)
Dim am6 As AxisMarker = New AxisMarker("Labor Day",New Background(Color.LightBlue),New DateTime(2017, 9, 2),New DateTime(2017, 9, 4))
Chart.XAxis.Markers.Add(am6)
Dim am7 As AxisMarker = New AxisMarker("Columbus Day",New Background(Color.LightBlue),New DateTime(2017, 10, 7),New DateTime(2017, 10, 9))
Chart.XAxis.Markers.Add(am7)
Dim am8 As AxisMarker = New AxisMarker("Thanksgiving",New Background(Color.LightBlue),New DateTime(2017, 11, 21),New DateTime(2017, 11, 23))
Chart.XAxis.Markers.Add(am8)
Dim am9 As AxisMarker = New AxisMarker("Veterans Day",New Background(Color.LightBlue),New DateTime(2017, 11, 10),New DateTime(2017, 11, 12))
Chart.XAxis.Markers.Add(am9)
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<dnc:Chart ID="Chart" runat="server" style="max-width:900px;margin:0px auto;"/>
</body>
</html>
Previous