dotnetCHARTING Send comments on this topic.
DateGrouping Property
See Also  Example
dotnetCHARTING Namespace > ChartArea Class : DateGrouping Property


Gets or sets a TimeInterval enumeration which determines how the values of a given series are aggregated by date when retrieved from a database.

Syntax

Visual Basic (Declaration) 
Public Property DateGrouping As TimeInterval
Visual Basic (Usage)Copy Code
Dim instance As ChartArea
Dim value As TimeInterval
 
instance.DateGrouping = value
 
value = instance.DateGrouping
C# 
public TimeInterval DateGrouping {get; set;}

Example

C#Copy Code
           [C#]
Chart.DateGrouping = TimeInterval.Days;
    
C#Copy Code
           [Visual Basic]
Chart.DateGrouping = TimeInterval.Days
    

Remarks

Controls how the values of a given series are grouped by date. In order to use this option the second column returned by the SqlStatement must be a date/time. Options include Minutes, Hours, Days, Weeks, Months, Quarters and Years where any StartDate and EndDate can be used and the chart will show all values sequentially. There are additional options for Hour/Minute, Day/Hour, Week/Day, Month/Day, Year/Quarter and Year/Month in these cases there are 2 special considerations 1) only a single day / week / month / or year is charted and 2) if the date range is greater than the period type (e.g. 1 day / 1 week / 1 month / 1 year) values are totalled over that period. There are also shortcuts for the grouping cases of Hour (Hours/Minute), Day (Day/Hour), Week(Week/Day), Month (Month/Day) and Year (Year/Month). See all time interval options. This feature automatically groups multiple data points over a given date range into the specific date grouping you select. When DateGrouping is enabled you must ensure that each series within a given chart returns date/time data for the second column returned by the SqlStatement.

See Also

© 2018 All Rights Reserved.