i am trying to create a crosstab view from a list of items using the following code :
'Create and configure the Crosstab data provider Dim cfxCT As ChartFX.WinForms.DataProviders.CrosstabDataProvider = New ChartFX.WinForms.DataProviders.CrosstabDataProvider cfxCT.NullColumnHeading = "N/A" cfxCT.DataSource = Data ' Instruct Chart FX how to use the fields in the Crosstab. Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("BusEventCategory", ChartFX.WinForms.FieldUsage.RowHeading)) Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("CreatedBy", ChartFX.WinForms.FieldUsage.ColumnHeading)) Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("TotalCost", ChartFX.WinForms.FieldUsage.Value)) Chart1.DataSource = cfxCT
croostab view and aggregation for value field
in Windows Forms
Posted
i am trying to create a crosstab view from a list of items using the following code :
'Create and configure the Crosstab data provider Dim cfxCT As ChartFX.WinForms.DataProviders.CrosstabDataProvider = New ChartFX.WinForms.DataProviders.CrosstabDataProvider cfxCT.NullColumnHeading = "N/A" cfxCT.DataSource = Data ' Instruct Chart FX how to use the fields in the Crosstab. Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("BusEventCategory", ChartFX.WinForms.FieldUsage.RowHeading)) Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("CreatedBy", ChartFX.WinForms.FieldUsage.ColumnHeading)) Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("TotalCost", ChartFX.WinForms.FieldUsage.Value)) Chart1.DataSource = cfxCT
My issue has to with this line:
ChartFX.WinForms.FieldMap("TotalCost", ChartFX.WinForms.FieldUsage.Value)
how do i define what aggregation to do with the totalcost field (sum, count , min , max etc )
giannis.