Documentation

    Vista Filters

    Vista Filters defines the filters dashboard readers can use on a table. It sits directly before a Vista Source and connects to a Filter control in Vista. When a reader picks a value, every visual in the filter's scope shows only the matching rows. Base rows passes the table on unfiltered, and each filter adds its own output, named after the filter, which connects to its Filter control. Under **Expose result in Strata**, you can also add a named output that passes on the rows matching a chosen set of filters.

    Filter a chart from its source

    The chart and the Drink filter at the top are Vista. Below them, Vista Filters sits between Manual Input and Vista Source. You can select the filter; the rest is read-only.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    Result
    DrinkCups
    Tea4
    Latte9
    Mocha6
    1. With All selected, the chart shows Tea 4, Latte 9 and Mocha 6.
    2. Select Latte in the Drink filter. The chart redraws with one column, Latte 9.
    3. Select All. All three columns return.
    4. Look at the flow. Base rows, the unfiltered output of Vista Filters, connects to Vista Source. The Drink output, which the Drink filter adds, connects to the filter control above the chart.

    When to use

    Use Vista Filters when readers of a dashboard should narrow what they see, for example by region or product. Setting up a Filter control in Vista can create this block for you. To change the data itself for everyone, use the standard Filter block.

    The filtered table reaches Vista through Vista Source.

    To apply a fixed condition in the flow, use Filter.

    Inputs and outputs

    Inputs

    1 port
    DataRequired

    Accepts: Tables.

    Accepts one connection on this port.

    Outputs

    1 port
    Base rows

    Configure the block

    Filters

    The filters readers can use. Each one has a name, the column it filters, how it appears and which visuals it applies to.

    Vista Filters FAQs

    How is this different from the Filter block?
    The Filter block applies a fixed condition you set in Strata. Vista Filters applies whatever the dashboard reader chooses.
    Can I use a Parameter or custom SQL in Vista Filters?
    No. Vista Filters reports an error for both. Use Formula or the standard Filter block.

    Prepare your data. Build it in Strata.

    Strata opens in your browser, with no account.