Data Product - Filter add complexity
The filter functionality needs to be modified. As a first step, we should add operators (e.g., =, <, >, <=, >=). This will allow users to create complex conditions.
For example, let’s assume the data product includes the fields: id, humidity, country, and date. Users could then create filters such as:
- id = X AND id = Y
- id = X OR id = Y
- humidity > 7 AND country = Greece
- humidity > 7 AND (country = Greece OR country = Spain)
- date >= 2021 AND humidity > 7 AND date <= 2024 AND country = Greece