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.
Vista Filters interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| Drink | Cups |
|---|---|
| Tea | 4 |
| Latte | 9 |
| Mocha | 6 |
- With All selected, the chart shows Tea 4, Latte 9 and Mocha 6.
- Select Latte in the Drink filter. The chart redraws with one column, Latte 9.
- Select All. All three columns return.
- 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.