Open the
Create Report Definition window by selecting the
Create report definition icon at the top right of the dashboards panel.
You can also open the
Create Report Definition window from the
DEFINED REPORTS page, either by adding a new report definition or by editing an existing definition.
There are four ways to edit filters:
Left pane
The left pane contains a list of all available fields:
- Click on a field to open a list of the top five values of the fields in the database.
- Click the magnifying glass icons with plus sign to right of the value to add the value as a filter.
- Click the magnifying glass icon with the minus sign to filter out the table for this value.
Top filters area
Use the filters at the top of the
DEFINE REPORT dialog to:
- Click a selected filter to open a drop-down list with the following options:
- Edit filter
- Exclude results
- Temporarily disable
- Delete
- Click the
x button to the right side of the filter removes the filter.
- Click
Add filter to add a new filter.
Table column values
If at least one column is displayed, hover over a value in the table to show a magnifying glass icon with a plus and minus
sign, Use this to filter for or filter out the table for this value.
Table row fields
Click the arrow to the left of a row in the table to show all the fields of that row. Hovering over a field provides the following
options:
- Filter for value: show only rows with this field equals this value. First icon from the left.
- Filter out value: show only rows with this field not equals this value. Second icon from the left.
- Filter for field present: show only rows with this field present. Fourth icon from the left.