How to: Bind a Scatter Chart Dashboard Item to Data in Code

• Mar 31, 2018
• 2 minutes to read

The following example demonstrates how to bind a Scatter Chart dashboard item to data in code.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-bind-a-scatter-chart-dashboard-item-to-data-in-code-t306222.

Form1.vb

Imports System
Imports DevExpress.DashboardCommon

Namespace Dashboard_CreateScatterChart
    Partial Public Class Form1
        Inherits DevExpress.XtraEditors.XtraForm

        Public Sub New()
            InitializeComponent()
        End Sub

        Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load
            ' Creates a new dashboard and data source for this dashboard.
            Dim dashboard As New Dashboard()

            ' Creates an OLAP dashboard data source based on the connection string 
            ' stored in the app.config file.
            Dim olapDataSource As New DashboardOlapDataSource()
            olapDataSource.ConnectionName = "AdventureWorksString"
            dashboard.DataSources.Add(olapDataSource)

            ' Creates a scatter chart and binds it to data.
            Dim scatterChart As New ScatterChartDashboardItem()
            scatterChart.DataSource = olapDataSource
            scatterChart.AxisXMeasure = New Measure("[Measures].[Sales Amount]")
            scatterChart.AxisYMeasure = New Measure("[Measures].[Gross Profit Margin]")
            scatterChart.Arguments.Add(New Dimension("[Product].[Category].[Category]"))
            scatterChart.Weight = New Measure("[Measures].[Gross Profit]")

            ' Adds the scatter chart to the dashboard and opens this
            ' dashboard in the Dashboard Viewer.
            dashboard.Items.Add(scatterChart)
            dashboardViewer1.Dashboard = dashboard
        End Sub
    End Class
End Namespace

Form1.cs

using System;
using DevExpress.DashboardCommon;

namespace Dashboard_CreateScatterChart {
    public partial class Form1 : DevExpress.XtraEditors.XtraForm {
        public Form1() {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e) {
            // Creates a new dashboard and data source for this dashboard.
            Dashboard dashboard = new Dashboard();

            // Creates an OLAP dashboard data source based on the connection string 
            // stored in the app.config file.
            DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource();
            olapDataSource.ConnectionName = "AdventureWorksString";
            dashboard.DataSources.Add(olapDataSource);

            // Creates a scatter chart and binds it to data.
            ScatterChartDashboardItem scatterChart = new ScatterChartDashboardItem();
            scatterChart.DataSource = olapDataSource;
            scatterChart.AxisXMeasure = new Measure("[Measures].[Sales Amount]");
            scatterChart.AxisYMeasure = new Measure("[Measures].[Gross Profit Margin]");
            scatterChart.Arguments.Add(new Dimension("[Product].[Category].[Category]"));
            scatterChart.Weight = new Measure("[Measures].[Gross Profit]");

            // Adds the scatter chart to the dashboard and opens this
            // dashboard in the Dashboard Viewer.
            dashboard.Items.Add(scatterChart);
            dashboardViewer1.Dashboard = dashboard;
        }
    }
}