Work with filters in Model View

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15

In this example, you want to explore motorcycle sales data for countries in the EMEA geography field. In Model View, drag a field from the Available Fields panel to the Filters panel, define the value to use in the Value field, and then apply the filter to the visualization.
  1. From the Available Fields panel, drag the 'TERRITORY' to the Filters panel.


    Filters Panel Value Entry

  2. From the interactive filters menu, make your selections to apply the filter to a visualization.


    Equals Filter Example

    When the filter is applied, the Filter panel updates 'TERRITORY' to equal 'EMEA', and the pivot table updates to only show sales in countries in Europe, the Middle East and Africa.