Providing Data

• Dec 22, 2020
• 3 minutes to read

The Dashboard Designer allows you to bind dashboard items to data in a uniform and similar manner. See the Bind Dashboard Items to Data topic for common information.

The difference is in the data sections that the specific dashboard item has. This topic describes how to bind the Bubble Map dashboard item to data in the Designer or in code.

• Binding to Data in the Designer
• Example

Binding to Data in the Designer

The image below shows a sample Bubble Map dashboard item that is bound to data.

Note that the Bubble Map provides two data item groups for data binding: DATA ITEMS and TOOLTIP DATA ITEMS. Tables below list the available data sections.

Data Items

Section	Processed as	Description	API
Latitude	Dimension	Accepts a dimension used to provide geographic latitude.	GeoPointMapDashboardItemBase.Latitude
Longitude	Dimension	Accepts a dimension used to provide geographic longitude.	GeoPointMapDashboardItemBase.Longitude
Weight	Measure	Accepts a measure used to evaluate the bubble’s weight.	BubbleMapDashboardItem.Weight
Color	Measure	Accepts a measure used to evaluate the bubble’s color. The Bubble Map dashboard item automatically selects palette and scale settings used to color bubbles. To customize these settings, click the Options button next to the Color placeholder. This invokes the Color Scale Options dialog, which allows you to specify the palette and scale options. To learn how to use this dialog, see Coloring.	BubbleMapDashboardItem.Color

Tooltip Data Items

Section	Processed as	Description	API
Dimensions	Dimension	Accepts dimensions allowing you to add supplementary content to the tooltips.	GeoPointMapDashboardItemBase.TooltipDimensions
Measures	Measure	Accepts measures allowing you to add summaries to the tooltips.	MapDashboardItem.TooltipMeasures

Example

The following code snippets show how to bind a Bubble Map dashboard item to data in code and customize the item’s palette.

Form1.cs

using System;
using System.Collections.Generic;
using DevExpress.DashboardCommon;
using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
using DevExpress.XtraEditors;

namespace Dashboard_CreateBubbleMap {
    public partial class Form1 : XtraForm {
        public Form1() {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e) {
            Dashboard dashboard = new Dashboard();
            DashboardSqlDataSource dataSource = new DashboardSqlDataSource(); 
            dataSource.ConnectionParameters =
                new XmlFileConnectionParameters(@"..\..\Data\DashboardEnergyStatictics.xml");
            SelectQuery sqlQuery = SelectQueryFluentBuilder
                .AddTable("Countries")
                .SelectColumns("Latitude", "Longitude", "Production", "Import", "Country")
                .Build("Countries");

            dataSource.Queries.Add(sqlQuery);
            dashboard.DataSources.Add(dataSource);

            BubbleMapDashboardItem bubbleMap = new BubbleMapDashboardItem();
            bubbleMap.DataSource = dashboard.DataSources[0];
            bubbleMap.DataMember = "Countries";

            bubbleMap.Area = ShapefileArea.Europe;

            bubbleMap.Latitude = new Dimension("Latitude");
            bubbleMap.Longitude = new Dimension("Longitude");

            bubbleMap.Weight = new Measure("Production", SummaryType.Sum);
            bubbleMap.Color = new Measure("Import", SummaryType.Sum); 
            bubbleMap.Color.NumericFormat.FormatType = DataItemNumericFormatType.General;

            bubbleMap.TooltipDimensions.Add(new Dimension("Country"));

            CustomizeScale(bubbleMap);
            ShowLegends(bubbleMap);

            dashboard.Items.Add(bubbleMap);
            dashboardViewer1.Dashboard = dashboard;
        }
        private void CustomizeScale(BubbleMapDashboardItem map) {
            CustomScale customScale = new CustomScale();
            List<double> rangeStops = new List<double>();

            customScale.IsPercent = false;

            rangeStops.Add(20);
            rangeStops.Add(200);
            rangeStops.Add(500);
            rangeStops.Add(2000);
            customScale.RangeStops.AddRange(rangeStops);

            map.ColorScale = customScale;
        }
        private void ShowLegends(BubbleMapDashboardItem map) {
            map.Legend.Visible = true;
            map.Legend.Orientation = MapLegendOrientation.Horizontal;
            map.WeightedLegend.Visible = true;
            map.WeightedLegend.Position = MapLegendPosition.BottomLeft;
        }
    }
}

Form1.vb

Imports System
Imports System.Collections.Generic
Imports DevExpress.DashboardCommon
Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
Imports DevExpress.XtraEditors

Namespace Dashboard_CreateBubbleMap
    Partial Public Class Form1
        Inherits XtraForm

        Public Sub New()
            InitializeComponent()
        End Sub

        Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
            Dim dashboard As New Dashboard()
            Dim dataSource As New DashboardSqlDataSource()
            dataSource.ConnectionParameters = New XmlFileConnectionParameters("..\..\Data\DashboardEnergyStatictics.xml")
            Dim sqlQuery As SelectQuery = SelectQueryFluentBuilder.AddTable("Countries").SelectColumns("Latitude", "Longitude", "Production", "Import", "Country").Build("Countries")

            dataSource.Queries.Add(sqlQuery)
            dashboard.DataSources.Add(dataSource)

            Dim bubbleMap As New BubbleMapDashboardItem()
            bubbleMap.DataSource = dashboard.DataSources(0)
            bubbleMap.DataMember = "Countries"

            bubbleMap.Area = ShapefileArea.Europe

            bubbleMap.Latitude = New Dimension("Latitude")
            bubbleMap.Longitude = New Dimension("Longitude")

            bubbleMap.Weight = New Measure("Production", SummaryType.Sum)
            bubbleMap.Color = New Measure("Import", SummaryType.Sum)
            bubbleMap.Color.NumericFormat.FormatType = DataItemNumericFormatType.General

            bubbleMap.TooltipDimensions.Add(New Dimension("Country"))

            CustomizeScale(bubbleMap)
            ShowLegends(bubbleMap)

            dashboard.Items.Add(bubbleMap)
            dashboardViewer1.Dashboard = dashboard
        End Sub
        Private Sub CustomizeScale(ByVal map As BubbleMapDashboardItem)
            Dim customScale As New CustomScale()
            Dim rangeStops As New List(Of Double)()

            customScale.IsPercent = False

            rangeStops.Add(20)
            rangeStops.Add(200)
            rangeStops.Add(500)
            rangeStops.Add(2000)
            customScale.RangeStops.AddRange(rangeStops)

            map.ColorScale = customScale
        End Sub
        Private Sub ShowLegends(ByVal map As BubbleMapDashboardItem)
            map.Legend.Visible = True
            map.Legend.Orientation = MapLegendOrientation.Horizontal
            map.WeightedLegend.Visible = True
            map.WeightedLegend.Position = MapLegendPosition.BottomLeft
        End Sub
    End Class
End Namespace