You can create a new Derived Report after adding filters to any existing report or table.
Add filters to a report or table, then click Create Derived Report under Actions.
Enter a name for the new report and add more filters if necessary.
Click Prefill to add all columns from the data source to the new report. Click the trash icon to remove columns. You can also manually add columns one by one by clicking Add Extraction/Grouping.
If no columns are added, either manually or via prefilling, the resulting derived report will be empty.
To transform the data from the source report, select an operation under Process, then enter a name in the Derived Column field. Otherwise, leave it on No Processing with the default name.
Click Add metric to perform additional calculations using the derived columns added in the previous steps as inputs. Enter different derived column names in the Calculation field and add mathematical operators.
Autocomplete options will appear as you are typing. If not, you might be typing in a derived column name that hasn’t been added yet.
To tag or label all rows in the derived report with a new attribute, click Add New Column. Enter a column name and specify a value to add to all fields in the column.
Click Apply.