---
schema_version: "1"
id: bddc7455aed0614d501e2e40842713a49de0e9f48ad4ef0be09b484bc9ec12d3
title: Considerations for 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_connected_sources_considerations_concept.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_connected_sources_considerations_concept.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1f469c7e42adc998a2517bc7cc1cb3cf0ebee68e2cc2b46ea9656416cefc97a7
description: Keep these considerations in mind when faceting queries from different datasets.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Considerations for Connected Data Sources

Keep these considerations in mind when faceting queries from different datasets.

Selecting Connection Fields

Faceting only works on the fields used to define the connection. For example, the connection in the following screenshot is based on the StageName field. As a result, the StageName list widget is faceted to the bar chart. If a selection is made in the Account.Type list widget, faceting doesn’t happen—the results aren’t filtered. To enable faceting on the Account.Type field, define another connection based on this field using the same data sources.

![The list widget based on stage name is faceted. Not the Acount Type list widget.](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_data_source_connection_example.png)

Selection Persistence

Removing a filter doesn't automatically remove its selections, and its impact on those selections still remain. Selections have to be manually reset.

![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 Selection persistence applies whether the queries are within the same dataset or connected across multiple datasets.

Connecting Date Fields

When using date fields to connect datasets you must use time periods that describe the top-level date field. For example, if you want to group by Close Date \[top-level\] in a lens, you’re prompted to select time periods, such as Close Date (Year) \[time period\] or Close Date (Year-Quarter) \[time period\].

- Create a filter widget with a time period of your choice, such as Close Date (Year) or Close Date (Year-Quarter).
- Create a connection using Connect Data Sources in the dashboard builder, select the datasets, and top-level date field, such as Close Date, to connect.
- Open the dashboard JSON, press Ctrl+E (Windows), Cmd+E (macOS).
- Press Ctrl+F (Windows), Cmd+F (macOS), and search for dataSourceLinks.
- Update “fieldName” by replacing its current value with the time period used in the filter widget. Separate multiple time periods with \~~~ as shown in the example.

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

Example

```
     "dataSourceLinks": [
            {
                "name": "Link_544",
                "label": "Close Date Connection",
                "fields": [
                    {
                        "fieldName": "Close_Date_Year~~~Close_Date_Quarter",
                        "dataSourceName": "DTC_Opportunity",
                        "dataSourceType": "dataset"
                    },
                    {
                        "fieldName": "Close_Date_Year~~~Close_Date_Quarter",
                        "dataSourceName": "ACME_Opportunities",
                        "dataSourceType": "dataset"
                    }
                ]
            }
        ],
```

#### See Also

- [Configure Cross-Dataset Faceting with Connected Data Sources](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_data_source_connections.htm&release=264.0.0&type=5 "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.")