Drill to Category Chart Type with Category Object filters

When drilling from a chart to a category using the Drill to Category Chart Type, all the Category Object filters will be passed to the destination category in the same way that a normal drill down works.

When using this Chart Type please bear in mind the following points:

• The destination category must have Category Objects enabled, the passed filters (from the source category) are then used to fill in these Category Objects.

• Any extra filters from the source category will be ignored in the destination category, for example if you’ve filtered the chart on the source category by using a ‘Top’ filter

• If the destination Category has a default value set for a Category Object it will be overridden if the Category Object on the source Category is a different value when Drill to Category is used

• If the source Category has ‘All’ set for a Category Object, the destination category will also be filtered to ‘All’ when Drill to Category is used. This also applies if the destination category has a default value set.

The following information relates to how filters are excluded:

• If the ‘Filter’ box has been unticked for the Category Object filter on the source category, the Category Object filter on the destination category will not be changed when Drill to Category is used

• If ‘Manually apply category filters’ is selected on the source category, the Category Object filter on the destination category will not be changed when Drill to Category is used

• If the Dimension ‘Enable drill down filter’ is unticked on the source Category, the destination category will not be changed when Drill to Category is used

• Source chart Measures won't be passed to destination category

Operators

Filters can have different operators, while each category object type only supports one operator.

• If the filter (the source) is using an operator that the category object (destination) accepts, the value is kept

• Otherwise the filter is ignored

The following list shows the current supported Operators of each category object type, and the filter operators that can be used to set these category objects:

• SELECT - EQUAL_TO - (accepts: EQUAL_TO)

• SEARCH - IN - (accepts: IN, EQUAL_TO)

• CHECKBOXES - IN - (accepts: IN, EQUAL_TO)

• IMAGES - IN - (accepts: IN, EQUAL_TO)

• NUM_PICKER - EQUAL_TO - (accepts: EQUAL_TO)

• SLIDER - BETWEEN - (accepts: BETWEEN)

• FREE_TEXT - LIKE - (accepts: LIKE, EQUAL_TO)

• SINGLE_DATE_PICKER - EQUAL_TO - (accepts: EQUAL_TO)

• DATE_PICKER - BETWEEN - (accepts: BETWEEN)