Filtering Data in Visualizer

Use the Filters bucket in the Chart Builder to filter the data in one of the following ways:

Drag and drop a measure or attribute from the Subject Area onto the Filters bucket.

  • Filter on measures and attributes that have already been added to the report, as described in the following section.
  • Alternatively, you can also visually filter a report by dragging a capture rectangle around attribute values in the chart. See Visually Filtering a Visualization.

Tip: When starting a new report, you can add a measure or attribute to the Filters bucket first and configure the filter before adding the measures and attributes. The filter will be applied to any measures and attributes that you subsequently add.

Important: Set-based filters (BQL IN, NOT IN) are not supported in Visualizer.

To filter the data in a report

  1. In Visualizer, add one or more measures and attributes to plot a chart. For example, Days Inventory on Hand by Retailer Country sorted by Days Inventory on Hand.
  2. Search for or drag and drop a relevant column onto the Filters bucket. For example, drag and drop Retailer Country onto the Filters bucket.
    The Filter Editor opens.

    Tip: The Filter Editor lists the first 100 values, though you can find additional values using search.
  3. Select the filter style. Styles are available based on the data type. Styles include:
    • Check list (check box): for multi-select text-based or numeric data types.
    • Slider: for date, datetime, and integer data types.
    • Value: for text-based data.
    • Date picker: for date data types. See Tip below.
  4. Select the filter operator. You can:
    • Select values from the list and use the operators to specify a filter set.

    • If there is a long list of filters, use the Search field to quickly find the ones you need.

    • For long lists, use the Show Selected Options only button.

      Click it again to see and scroll the first 100 options.

    • If you want the filter to apply against the query result set in memory, select the More Options - Use as a display filter option. By default this setting is off and the filter operation is carried out at the data source.

      For details see Introduction to BQL - Queries and Where Calculations Occur.
  5. Click Apply.

    The chart updates to reflect the filter applied to the data.
  6. Select the Filter bucket to see the current filter.

Tips:

  • You can toggle the filter on and off using the toggle switch. In a dashboard, when a filter is toggled off it maintains its state, but it is not applied to the dashboard.
  •  To change the filter condition, click on the filter name in the Filters bucket.
  • A report can have multiple filters.
  • A filter column does not have to be in the Category bucket; it does not have to display in the report.
  • If you want to filter on a column you are already using in your chart, you can drag the column from its current bucket to the Filters bucket. Visualizer will not remove it from the current bucket and will add it to the Filters bucket.
  • You can remove the filter by clicking the Remove icon.
  • You can use a Visualizer report expression as a filter by dragging and dropping it to the Filters bucket. However, you cannot filter the data in a report using a saved expression created in Designer.
  • To filter on date type attributes, use the range (between)  condition and the date picker.
  • Text-based value filters can have multiple values separated by a delimiter. Toggle Allow Multiple Values and specify the values and what delimiter to use.
  1. Click Save .

Learn More