add_visual_filter
Add a visual-level filter to exclude unwanted rows from tables and rankings, using comparison operators like gt, lte, or isnotblank to remove zero or blank values.
Instructions
Add a VISUAL-LEVEL filter to an existing visual. op = gt|gte|lt|lte|eq|ne|isblank|isnotblank. kind=column|measure. The classic use: exclude discontinued/zero rows from a ranking table, e.g. op=isnotblank on 'Sales 52W TY' (or op=gt value=0), so -100%/blank-rank SKUs stop cluttering the top. valueType=int|decimal|string (default decimal) for comparison values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| op | No | gt|gte|lt|lte|eq|ne|isblank|isnotblank | isnotblank |
| kind | No | column|measure | measure |
| field | Yes | field (column or measure) to filter on | |
| table | Yes | table that owns the filter field | |
| value | No | comparison value (ignored for isblank/isnotblank) | |
| pageName | Yes | ||
| valueType | No | int|decimal|string | decimal |
| visualName | Yes | ||
| reportSessionId | Yes |