Documentation

    Parameters and filters

    A filter removes rows from what visuals receive. A parameter is a value readers can change, used by a calculation or a Strata block setting. Both are controls on the dashboard and both work through your flow.

    See a parameter and a filter working

    Try both below. Late after (hours) is a parameter: it changes who counts as on time. Region is a filter: it changes which shipments are counted.

    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
    CarrierRegionHoursCostOn time
    NorthwindDACH228.73100
    NorthwindDACH258.94100
    NorthwindDACH278.51100
    NorthwindDACH3610.45100
    NorthwindDACH3110.16100
    NorthwindDACH3810.470
    NorthwindDACH217.9100
    NorthwindDACH419.550

    The flow is under the dashboard. A Vista Parameter block feeds the Formula block, and a Vista Filters block sits before the Vista Source.

    Which one do I need?

    CompareFilterParameter
    What it doesRemoves rows by a columnSupplies one value
    ExampleOnly the NordicsLate after 36 hours
    In StrataVista FiltersVista Parameter

    Add a filter

    1. Open Controls in the palette and double-click Filter.
    2. In Properties, choose a Source and pick a field under Available filter fields. Vista creates the Vista Filters block.
    3. Set Control, and turn on Allow multiple selections, Exclude selection or Include missing values if you need them.
    4. Set Applies to: This page, Selected visuals or All pages using this source.
    5. Set Available choices to control which values are offered. Relevant values is the default.
    6. Use Show in Strata to see the block behind the filter.

    A Legend can act as the same control, if you connect it to a filter.

    Add a parameter

    1. Open Controls and double-click Parameter.
    2. Select Create parameter. Choose Calculation or Control a Strata block.
    3. For Calculation, select Create and continue in the Name dialog. Choose Data for this calculation, select Create a calculation, then write an expression and select Create calculation. This adds a Formula block that reads the parameter as params.name.
    4. For Control a Strata block, choose a block and a setting, then select Connect. The value now drives that setting. If the value's bounds conflict, Connect stays disabled and Auto align is offered.
    5. In Properties, set Type, Value, Allowed values, Minimum, Maximum and Step. Add another use connects the same parameter somewhere else.

    Read Calculations for how this fits with chart and KPI calculations.

    What viewers can do

    Filters and parameters stay usable on a published dashboard. Viewer selections affect only their own session.

    Filter choices and calculated results in the editor also follow the preview sample. See previews use a sample.

    Next

    • Appearance settings for the Filter control. Setup is under Add a filter on this page.

    • Appearance settings for the Parameter control. Setup is under Add a parameter on this page.

    Parameters and filters FAQs

    Can a filter hide rows from certain viewers?
    No. Viewers can access the input data used by a dashboard, whatever filter is selected.
    Can one filter affect several pages?
    Yes. In Applies to, choose All pages using this source.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.