The formatting options for filters are now found on the report preview page when in draft mode, along with columns and sections.
The main formatting options for report filters are displayed below.
- The User Prompt location allows you to choose where the filter box will appear in relation to the report results, with the options; Top, Bottom, Left, and Right
- The Apply link can be moved so that it is displayed at the Top, Bottom or Top and Bottom of the filters box.
- The Apply Style allows you to change the formatting of the Apply Filters link between Button and Apply Text.
- Filter Width allows you to adjust the width of the text boxes and lists to accommodate longer values.
- The Display option allows you to choose if you wish to have a list of filters used to display with the report results, either at the Top or Bottom of the results.
- Automatically Apply Filters: Yes, No
- Drill Filters: Hidden, Closed, Open (breadcrumbs)
- Minimise Filter Section allows you to collapse or expand the filter box.
- Enable Saved Filter Sets will allow users with the required role permissions to use filter sets on the report.
Dimension Specific Filter Formatting
When using a dimension as a filter you will have dimension specific options available in the Display and Entry Style filter menus. These options will allow you to define various settings, such as filter caching, custom descriptions and list length (if using an In List operand). These options may differ from the ones available when using a metric or a date.
- Display Filter
- The Description option allows you to change the display text from the default field name to a customised label.
- You can choose to let the user skip the current filter by selecting 'Allow Omit', you can have the filter set to 'Omit By Default' or you can make it mandatory, removing the omit option from the filter box.
- You can set filters to be dependent on other filters, so they are only displayed when the main filter has a value selected.
Note: This will only be displayed if you have another filter that had cached values.
See User Prompt Filters for more information.
Entry Style Menu
- If User Entry is selected you will be able to define whether you want the prompt list option to be available to the user or not
Note: It is recommended that the user prompt option be disabled if your data set has many variables that as it may take some time for the values to be returned.
- If Drop-Down is selected instead of User Entry then you will get the above menu.
- You can either choose to cache the values manually or schedule a task to regularly update them, or you can write a custom query to select values for the filter.
- The Default Value shows you how the filter will be displayed in the filter box.
Metric Specific Filter Formatting
Metric filters options only permit you to change the title/description, determine the omit option, and set default values. There is no prompt option for metrics.
The display options for metrics are the same as those for dimensions. Please see the previous section for details.
Entry Style Menu
- The Entry Style menu for a metric will just display the default value options, no other options are required. In this case, the filter used was set to 'In List' so there is a list setup, this will change depending on the operand selected.
Date Specific Filter Formatting
Date filter options allow you to: change the title/description of the filter, enable use of predefined ranges, and cache values.
The display options for dates are the same as those for dimensions and metrics. Please see the dimension section for details.
Entry Style Menu
- Selecting the User Entry option will allow you to set default values for you dates either by selecting a date using the calendar or prompt, or setting a date relative to the current system date.
- Selecting the Drop Down option will permit you to cache values, use a custom query or select from a set of predefined date ranges.