---
schema_version: "1"
id: 8aaf15ab99744960b6718617d30ea9e362c1e91d664cccc3fd00a65cbe634430
title: Configure Cross-Dataset Faceting with Connected Data Sources
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_dashboard_data_source_connections.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_data_source_connections.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: de6ea96a2f34a43857e4a7ef5ad34fcbb742d6c12d2423475e6165aa67da9088
description: By default, queries from the same dataset are faceted—automatically filtering each other. To facet queries from different datasets or even custom queries in the dashboard designer, connect them using common fields between them.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Configure Cross-Dataset Faceting with Connected Data Sources

By default, queries from the same dataset are faceted—automatically filtering each other. To facet queries from different datasets or even custom queries in the dashboard designer, connect them using common fields between them.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note You can’t connect custom queries that specify date or measure ranges.

1. Click ![Edit button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_icon_edit_widget.png) to edit the dashboard.
2. Click ![Edit button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/analytics_dropdown_icon.png) and then select **Connected Data Sources**.
3. In Data Source Connections, on the **Connections** tab, click **New Connection**.
    
    ![The New Connection window shows that no connections have been created yet.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_new_connection.png)
4. Enter a name for the connection.
5. Click **Choose Data Source 1** to select the first data source. For each data source, select a dataset or a custom query used in the dashboard.
6. Select a field from the data source by choosing it from the menu or typing its API name into the search field. This enables CRM Analytics to match records between the specified sources.
    
    ![Searching for a field by API name.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_new_connection_2.png)
7. Click **Choose Data Source 2** to select the second source, and then select a field from the menu or API name.
8. To add another data source, click **Add Data Source**. This option appears after you connect two data sources.
    
    You can connect two or more data sources.
9. Click **Save**.

#### See Also

- [Manage Datasets in Dashboard Components](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_components_manage_datasets.htm&release=264.0.0&type=5 "You can control whether components inherit data source linking from the dashboard in which the component is created.")
- [Considerations for Connected Data Sources](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_connected_sources_considerations_concept.htm&release=264.0.0&type=5 "Keep these considerations in mind when faceting queries from different datasets.")