Every report or dashboard in Wink V2 can be customized by excluding specific rows using filter formulas
Video Walkthrough
For a visual walkthrough, watch the attached Loom video: how to exclude rows from your report or dashboard in Wink V2. It demonstrates the process step by step for easy reference.
Step 1: Enter Edit Mode
On a Dashboard: Hover over the upper-right corner of the widget you want to edit. Click on the three dots, then select Edit.
On a Report: Click on Edit located on the right-hand side of the report.
Step 2: Access the Filters Section
Click on the Filters section, then click Edit Filter.
Step 3: Apply a Filter Formula
By default, the filter specifies which rows to include. To exclude certain rows, you can use the "is not" or "different than" symbol (<>) in your formula.
For example, the formula might look like this: SQL
For example, the formula might look like this: SQL
This formula will exclude rows where:
- [Item Name] <> “Admin Time” excludes rows where the item name is Admin Time.
- AND [City] = ANY(“Fletcher”) includes only rows where the city is Fletcher.
- AND [Country] <> NULL excludes rows where the country field is empty.
Step 4: Save and Apply the Filter
Once your filter is set up, click Save to update the report or dashboard.