Providing Data

Oct 28, 2021
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 Treemap dashboard item to data in the Designer or in code.

The Treemap dashboard item has the Values and Arguments data sections that provide numeric and discrete categorical data, respectively. The steps below provide the most common scenarios of binding a Treemap to data.

Drop the Sales and Profit fields to the Values section.
Drop the Product Category field to Arguments.
Drop the child Product Sub-Category field into Arguments.
If the Arguments section contains several dimensions, you can group child tiles by values of the parent dimension. To group sub-categories inside corresponding categories, click the CategoryName menu button and select Group Tiles.

Providing Data in Code

To provide data for the Treemap dashboard item, use the following properties.

Values

TreemapDashboardItem.Values

| |

Arguments

TreemapDashboardItem.Arguments

Note

To group tiles by values of a specific dimension, enable the Dimension.GroupChildValues flag for this dimension.

Example

The following code snippets show how to bind a Treemap dashboard item to data in code.

Form1.cs
Form1.vb

csharp

using DevExpress.DashboardCommon;
using DevExpress.XtraEditors;

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

            Dashboard dashboard = new Dashboard();
            DashboardExtractDataSource dataSource = new DashboardExtractDataSource();
            dataSource.FileName = @"..\..\Data\SalesDataExtract.dat";
            dashboard.DataSources.Add(dataSource);

            TreemapDashboardItem treeMap = new TreemapDashboardItem();
            treeMap.DataSource = dataSource;
            treeMap.Values.Add(new Measure("Sales"));            
            treeMap.Arguments.Add(new Dimension {
                DataMember = "Product Category",
                GroupChildValues = true });
            treeMap.Arguments.Add(new Dimension("Product Sub-Category"));
            treeMap.LayoutAlgorithm = DashboardTreemapLayoutAlgorithm.Striped;

            dashboard.Items.Add(treeMap);
            dashboardViewer1.Dashboard = dashboard;
        }
    }
}

Imports DevExpress.DashboardCommon
Imports DevExpress.XtraEditors

Namespace DashboardViewer_Treemap
    Partial Public Class Form1
        Inherits XtraForm

        Public Sub New()
            InitializeComponent()

            Dim dashboard As New Dashboard()
            Dim dataSource As New DashboardExtractDataSource()
            dataSource.FileName = "..\..\Data\SalesDataExtract.dat"
            dashboard.DataSources.Add(dataSource)

            Dim treeMap As New TreemapDashboardItem()
            treeMap.DataSource = dataSource
            treeMap.Values.Add(New Measure("Sales"))
            treeMap.Arguments.Add(New Dimension With {.DataMember = "Product Category", .GroupChildValues = True})
            treeMap.Arguments.Add(New Dimension("Product Sub-Category"))
            treeMap.LayoutAlgorithm = DashboardTreemapLayoutAlgorithm.Striped

            dashboard.Items.Add(treeMap)
            dashboardViewer1.Dashboard = dashboard
        End Sub
    End Class
End Namespace