private Dashboard CreateDashboard() { DashboardExcelDataSource excelDataSource = CreateExcelDataSource(); Dashboard dBoard = new Dashboard(); dBoard.DataSources.Add(excelDataSource); dBoard.BeginUpdate(); // Create dashboard items. ChartDashboardItem chart = CreateChart(excelDataSource); dBoard.Items.Add(chart); DateFilterDashboardItem dateFilterItem = CreateDateFilterItem(excelDataSource); dBoard.Items.Add(dateFilterItem); DashboardItemGroup group = CreateGroup(); dBoard.Groups.Add(group); group.AddRange(dateFilterItem, chart); // Create layout tree. DashboardLayoutItem dateFilterLayoutItem = new DashboardLayoutItem(dateFilterItem, 30); DashboardLayoutItem chartLayoutItem = new DashboardLayoutItem(chart, 70); DashboardLayoutGroup groupLayoutItem = new DashboardLayoutGroup(group, 100); groupLayoutItem.ChildNodes.AddRange(dateFilterLayoutItem, chartLayoutItem); DashboardLayoutGroup rootGroup = new DashboardLayoutGroup(null, 100); rootGroup.ChildNodes.Add(groupLayoutItem); rootGroup.Orientation = DashboardLayoutGroupOrientation.Vertical; dBoard.LayoutRoot = rootGroup; dBoard.EndUpdate(); return(dBoard); }
private DateFilterDashboardItem CreateDateFilterItem(DashboardExcelDataSource excelDataSource) { DateFilterDashboardItem dateFilter = new DateFilterDashboardItem(); dateFilter.Name = string.Empty; dateFilter.ShowCaption = false; dateFilter.DataSource = excelDataSource; dateFilter.Dimension = new Dimension("orderDateId", "OrderDate", DateTimeGroupInterval.DayMonthYear); dateFilter.Dimension.DateTimeFormat.DateTimeFormat = DateTimeFormat.Short; dateFilter.ArrangementMode = DateFilterArrangementMode.Vertical; dateFilter.FilterType = DateFilterType.Between; dateFilter.DatePickerLocation = DatePickerLocation.Hidden; dateFilter.DateTimePeriods.AddRange( DateTimePeriod.CreateLastYear(), DateTimePeriod.CreateNextDays("Next 7 Days", 7), new DateTimePeriod { Name = "Month-to-date", Start = new FlowDateTimePeriodLimit { Interval = DateTimeInterval.Month, Offset = 0 }, End = new FlowDateTimePeriodLimit { Interval = DateTimeInterval.Day, Offset = 1 } }, new DateTimePeriod { Name = "Jul-18-2018 - Jan-18-2019", Start = new FixedDateTimePeriodLimit { Date = new DateTime(2018, 7, 18) }, End = new FixedDateTimePeriodLimit { Date = new DateTime(2019, 1, 18) } } ); return(dateFilter); }