Filter interactivity
In addition to the standard dashboard filter controls, JustAsk offers two ways to make filtering more interactive:
- Cross-filtering — viewers click chart elements to filter the rest of the dashboard
- Faceted filters — one filter narrows the options shown in another, for example a state filter narrowing a city filter to cities in that state
Both are off by default and configured per dashboard in the dashboard’s settings.
Requirements
Section titled “Requirements”Creating and modifying filters requires Editor, Manager, or Owner permissions on the document.
Cross-filtering
Section titled “Cross-filtering”Cross-filtering lets viewers filter a dashboard by clicking elements in a chart. When a viewer clicks a data point, bar, or other element, they get the option to create a filter that applies across all compatible tiles.
Cross-filters apply to any tile with a joinable relationship to the filtered field through the semantic model. When a cross-filter is active, tiles that it can’t filter will have a badge, which you can hover over to see why.
Supported visualization types
Section titled “Supported visualization types”Cross-filtering works with:
- Vega-Lite charts (bar, line, area, scatter, heatmap)
- Pie and donut charts
- Maps (choropleth and point)
- Data tables
- Sankey
Enabling cross-filtering
Section titled “Enabling cross-filtering”Cross-filtering is off by default. Enable it in the dashboard’s settings.
Creating a cross-filter
Section titled “Creating a cross-filter”There are several ways to create a cross-filter from a chart:
- Click-to-filter — click any chart element to filter the dashboard by that value
- Brush selection — on charts with a continuous axis (time series or numeric), click and drag to select a range. This creates a range filter on all compatible tiles.
- Multi-select — after creating a cross-filter on a discrete field,
Cmd + Click(Mac) orCtrl + Click(Windows) to add more values
Removing a cross-filter
Section titled “Removing a cross-filter”When a cross-filter is active, a chip appears below the dashboard filters. Click the on the chip to remove it.
Seeing which tiles a cross-filter affects
Section titled “Seeing which tiles a cross-filter affects”New cross-filters focus automatically. Click a cross-filter chip to focus it, or click it again to clear the focus.
While a cross-filter is focused, tiles it can’t filter will have a badge. Hover over the badge to see why the tile can’t be linked.
Limitations
Section titled “Limitations”- Cross-filters don’t apply to null values
- Linked tiles — tiles sourced from a separate workbook tab have their own query and can’t receive cross-filters
- Downloads do not apply cross-filter selections
Faceted filters
Section titled “Faceted filters”Faceted filters automatically link two filters so that one narrows the values of another. For example, a state filter limits the city filter’s options to only cities in the selected state.
Enabling faceted filters
Section titled “Enabling faceted filters”Faceted filters are off by default. Enable them in the dashboard’s settings.
Next steps
Section titled “Next steps”- Working with dashboard filters — create filters, set defaults, and connect them to tiles
- Filter display options — choose how filters are displayed to viewers
- Dashboard settings — toggle cross-filtering, faceted filters, and other dashboard behaviors