Every report in Wink V1 can be customized by excluding specific rows using filter formulas.
Video Walkthrough
For a visual walkthrough, How to exclude rows from your Report. It demonstrates the process step by step for visual reference.
Click on the report in the left corner, then open the report you want to adjust.
Hover over the left corner of the report, then click Design Report to enter edit mode.
Click on the Filters tab in the report designer.
In Wink V1, there are two types of filters:
- Data Source Filter – Applies to all columns in the data source.
- Post-Aggregation Filter – Applies only to the displayed columns in the report.
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
This formula will exclude rows where:
- [Item Name] <> “Admin Time is a long test” excludes rows where the item name is Admin Time.
- AND [Job City] = ANY(“Newtown”, “Coogee”) includes only rows where the cities are Newtown and Coogee.
- AND [Job Country] <> NULL excludes rows where the country field is empty.
Once your filter is set up, click Save and Run to update the report.
All the formula functions available are listed at https://support.winkreports.com/portal/en/kb/articles/report-designer-formula-reference