Filter and Search Functions

Filters can be set across maps, graphs, and tables — for example based on zone, ownership, material type, age, risk level, or time period. All filters work dynamically and update views immediately.

Filter vs. Search — Key Difference

If two datasets have columns/fields with the same name, you can filter both datasets simultaneously by using the search function. When using the filter function (green square), first select Data View and then the query.

If you have data from multiple sources — such as inflow data and pipe data — in the same dashboard, the filter will only point to one of them. The search field (highlighted in red) will, however, search through everything: if the name PS100 exists in both sources, both will be found, even if PS100 appears in fields with different names.

Example showing filter and search applied across multiple datasets — Example: The filter function (green square) targets a specific Data View, while the search field (red) searches across all datasets simultaneously.

Example: Display only pipes (from the pipes dataset) and failures (from the logbook entries dataset) on pipes made of grey cast iron. To achieve this, the material columns in the two datasets must have exactly the same name, and you must use search, not filter.

Filters Across Different Datasets

Note: If a dashboard contains graphs and visualisations based on different datasets, a filter based on one dataset will cause visualisations based on other datasets to become empty. The icon «no results found» will appear instead.

No results found icon shown when a filter is not valid for all datasets — Figure 2: Example: Using a filter that is not valid for all datasets in the dashboard will cause some visualisations to show «no results found».

For example: A dashboard consists of data from logbook entries and time series for rainfall. If you set a filter for material type, the rainfall data will disappear, as rainfall does not have the attribute «material type».

Filter and Search Functions