Report Console
      Back to home
      1. Help Center
      2. Publish
      3. Report Console

      Report Filters

      There are two types of filters available to you. Fixed Filters and Report Filters. 

      Fixed Filters

      Fixed filters limit the content that is available in a report by default.  One or more fixed filters may be used.

      Report Filters

      Report filters are available to users in the reporting interface. They provide users the capability to further refine the content displayed in a report. One or more report filters may be used. In the example below there are two filters available to a user.

      Screen_Shot_2020-08-14_at_3.05.11_PM.png

      Fixed Filter

      Updated_Fixed_Filter.png

      1. Cumulative Record Count Total number of records available based on entered criteria.
      2. Add/Delete Filter Add or remove the filter from the report.
      3. Column A list of the available columns in the Parent Dataset.
      4. Operator List of available filter operators.
      5. Filter Value The value(s) you are filtering.  You will be presented with a type-ahead list of the available values in the chosen column.

      Add a Fixed Filter

      1. Select Add Fixed Filter.
      2. Choose a Column.
      3. Select an Operator.
      4. Add a Filter Value.
      5. Click the Save button at the top right.
      6. Add report to a Site View, then verify it is displayed correctly in Pivvot. 

      Delete a Fixed Filter

      1. Select a filter in the Filter Preview window.
      2. Select Remove Selected Filter.
      3. Click the Save button at the top right.
      Report Filters

      Add a Report Filter

      1. Select Add Filter.
      2. Assign a Column.
      3. Create Label.
      4. Choose type of Filter, either Dropdown or Typeahead. 
      5. Click the Save button at the top right.
      6. Add report to your Site View, then verify it is displayed correctly in Pivvot. 

      There are two types of report filter options. You can choose from a Dropdown list or a Typeahead option. 

      Dropdown Filter Type

      Report_Filter_Dropdown_.png

      OR

      Typeahead Filter Type

      Report_Filter_Typeahead_.png

      1. Add/Delete Filter Add or remove a filter from the report.
      2. Column A list of the available columns in the Parent Dataset.
      3. Label The label you see next to the filter in the report.
      4. Type of Filter  Dropdown - Displays a list of available values from the configured column.

      Typeahead - A list of available values from the configured column will be displayed based on user input.
      5. Default Filter Option Toggle on to create default filter in report.
      6. Operator List of available filter operators.
      7. Filter Value The value(s) you are filtering.  You will be presented with a type-ahead list of the available values in the chosen column.

      Delete a Report Filter

      1. Select a filter in the Filter Preview window.
      2. Select Remove Selected Filter.
      3. Click the Save button at the top right.