# Faceting, selection and results interactions

*CRM Analytics and Einstein Discovery Consultant Study Guide · Analytics Dashboard Implementation · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/crm-analytics-and-einstein-discovery-consultant/analytics-dashboard-implementation/faceting-selection-and-results-interactions*

When faceting is enough and when to write a selection or results interaction, how Data Source Connections extend faceting across datasets, the data selection and serialization functions that shape a binding, and how to trace a binding that returns the wrong result.

- Certification: Salesforce CRM Analytics and Einstein Discovery Consultant
- Exam section: Analytics Dashboard Implementation
- Study guide: https://www.certifyforce.com/study-guide/crm-analytics-and-einstein-discovery-consultant

**Official exam objective:**

> Given business requirements, develop selection/result interactions with different types of queries.

## What the exam expects

- Decide whether faceting, a selection interaction or a results interaction meets a filtering requirement, including across datasets and SOQL queries.
- Configure faceting per receiving query (All, Include, Exclude, None) and connect data sources for cross-dataset faceting.
- Write an interaction with the right source, data selection function and serialization function for the target query form.
- Predict what a binding produces for multiple, null or empty selections, and bind initial selections, groupings, measures and limits.
- Use Show Details and View Query Details to trace a binding.

Key terms: **faceting** (selections in one widget automatically filter other queries); **selection interaction** (`.selection`, evaluated each time the user selects); **results interaction** (`.result`, driven by another query's results, no trigger); **data selection function** (`cell`, `column` or `row`, which picks data from a source); **serialization function** (`asObject`, `asString`, `asEquality` and others, which format that data for the target query); **Data Source Connections** (common-field links that let queries on different sources facet).

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Default faceting | Queries from the same dataset facet each other | [Faceting](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widgets_facet_flex.htm&type=5&language=en_US) |
| Where faceting is set | On the receiving query | [Faceting](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widgets_facet_flex.htm&type=5&language=en_US) |
| Broadcast selections as facets | On by default; read only for `soql` and `apex` (and for `aggregate`, `grain`, `static`, which use `isFacet`) | [Faceting](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widgets_facet_flex.htm&type=5&language=en_US) |
| Multi-dataset query | Facets on the first dataset in `datasets` | [Faceting](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widgets_facet_flex.htm&type=5&language=en_US) |
| Unconnectable sources | Custom queries with date or measure ranges | [Connected Data Sources](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_data_source_connections.htm&type=5&language=en_US) |
| Initial-selection bindings | Only `staticflex`, `saql` or `soql` queries | [Initial Selection](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-wave-designer-initial-selections.html) |
| Bound measure or grouping in a chart | Replace `columnMap` with an empty `columns` array | [Bind Parts of a Query](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-wave-designer-use-case-query-parts.html) |
| Row index | Starts at 0 | [Data Selection](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-functions-wave-designer-data-selection.html) |
| `asGrouping` with null | `group by all` | [Serialization](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-functions-wave-designer-data-serialization.html) |
| Bindings trace | Read from the bottom; final result at the top | [Troubleshoot](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboards_steps_troubleshooting.htm&type=5&language=en_US) |

## Check yourself

- What does `asGrouping` produce when its input is null?
- Why might a query built on two datasets broadcast only part of what users select?
- When does a data selection function raise an interaction error?
- When does a list widget hide its Show Details option?

## Sources

- [Get Started with Dashboard Interactions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dbjson-bindings.html)
- [Filter Dashboard Results with Faceting](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widgets_facet_flex.htm&type=5&language=en_US)
- [Configure Cross-Dataset Faceting with Connected Data Sources](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_data_source_connections.htm&type=5&language=en_US)
- [Interaction Syntax in the Dashboard](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-syntax-wave-designer.html)
- [Data Selection Functions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-functions-wave-designer-data-selection.html)
- [Data Serialization Functions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-functions-wave-designer-data-serialization.html)
- [Equality Filter Interactions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-wave-designer-use-case-filter-equality.html)
- [Bind the Initial Filter Selection](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-wave-designer-initial-selections.html)
- [Bind Parts of a Query](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-wave-designer-use-case-query-parts.html)
- [Measure and Group Bindings in Compact-Form and SAQL-Form Queries](https://developer.salesforce.com/docs/analytics/bi-dev-guide-bindings/guide/bi-dashboard-bindings-wave-designer-use-case-compactform-saqlform.html)
- [Troubleshoot Unexpected Query Results](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboards_steps_troubleshooting.htm&type=5&language=en_US)
- [soql Step Type Properties](https://developer.salesforce.com/docs/analytics/bi-dev-guide-json/guide/bi-dbjson-steps-types-soql.html)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 10 linked practice questions, and unlimited timed mock exams are included with the CRM Analytics and Einstein Discovery Consultant pack (USD $19): https://www.certifyforce.com/practice-exams