---
schema_version: "1"
id: 022756c046bd628133791d248626f2a10181cdb06e2ff440a7ae42f4c91163ea
title: Bind columnMaps in Dashboard Interactions
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_bindings/guides/bi-dashboard-bindings-columnmaps.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-columnmaps.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: a6d11ad868afc91271ab29747a874d391626949369305f59ec3c5d7e399afc75
products:
  - Analytics Interactions
  - analytics
---
# Bind columnMaps in Dashboard Interactions

Bind the `columnMap` parameter in a dashboard widget and in the widget section of your queries. Binding is useful when you have multiple measures or groupings and you want to control the order in which they're selected and portrayed in a chart.

This example shows how to bind the `columnMap` parameter in a custom (static) query and in an aggregateflex query in a simple dashboard. In the custom query, you can select either Industry or Country. The aggregateflex query shows ‘Sum of Amount’, grouped first by Industry and second by Opportunity Type and ordered by the Sum of Amount.

![Columns on the Dashboard Homepage](https://developer.salesforce.com/docs/media/bi_dev_guide_bindings/bi_dashboard_bindings_columnmap_1.webp)

The way the two queries interact is that the user selects a value from the custom query, which sets the first grouping in the aggregateflex query and is used in the X axis.

## Add the interaction to the groups parameter

On the right side of the page, click **Advanced Editor**, click the Query tab, and then locate the `groups` parameter in the JSON.

![Advanced Editor Query Tab](https://developer.salesforce.com/docs/media/bi_dev_guide_bindings/bi_dashboard_bindings_advanced_editor_query_tab.png)

Replace `Account.Industry` with the interaction.

```json
"groups": [
    "{{cell(SelectGroup_1.selection, 0, \"Dim\").asObject()}}",
    "Type"
],
```

## Add the Interaction to the columnMap Parameter

After you add your interaction to the `groups` parameter, locate the `columnMap` parameter in the JSON and add the interaction as the value of the `dimensionAxis` parameter.

```json
"columnMap": {
    "split": [
       "Type"
    ],
    "trellis": [],
    "dimensionAxis": [
      "{{cell(SelectGroup_1.selection, 0, \"Dim\").asObject()}}"
    ],
    "plots": [
       "A"
    ]
},
```

Click the **Widget** tab and then repeat this process.

After you add your interactions, save your changes, refresh the page, and then click **Preview** to view your dashboard with the `columnMap` bindings.