DateGrouping Property (DataEngine)
Gets or sets the date grouping of data returned from your database.
Syntax
'Declaration Public Property DateGrouping As TimeInterval
'Usage Dim instance As DataEngine Dim value As TimeInterval instance.DateGrouping = value value = instance.DateGrouping
public TimeInterval DateGrouping {get; set;}
Remarks
Controls how the values of a given series are grouped by date. In order to use this option the first 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 first column returned by the SqlStatement.
Controls how the values of a given series are grouped by date. In order to use this option the first 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 first column returned by the SqlStatement.
See Getting Started > Tutorials > Data Engine
Controls how the values of a given series are grouped by date. In order to use this option the first 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 first column returned by the SqlStatement.
See Getting Started > Tutorials > Data Engine
Example
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also