Filters in Zap Data Hub allow you to refine report results based on specific criteria. This is helpful when analysing performance metrics, for example, filtering staff by units worked or productivity percentage in the Staff Chargeable Productivity Report.
The steps below show how to apply multiple filter conditions.
Apply filters to a report
Right-click the Staff dimension under Rows, then select Set, then select Filter.
In the Condition field, drag Units Worked from the column area into the field.
Hover next to the inserted value to open the operator menu, then select > (greater than).
Enter 5000 in the field that appears. This filters out any staff with fewer than 5,000 units worked.
Hover next to the 5000 value and select And.
Drag Chargeable/Worked % from the column area into the Condition field.
Hover to open the operator menu, then select >.
Enter 0.5 (50%) in the field that appears. This filters out staff with more than 5,000 units worked but less than 50% chargeable productivity.
Click Apply.
The report will now display only staff who:
Worked more than 5,000 units, and
Have a Chargeable/Worked % greater than 50%.