Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

  • If the ‘Filter’ box has been unticked for the Category Object filter on the source categoryCategory, the Category Object filter on the destination category 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

  • CatA Source Category chart Measures won't be passed to CatB - not sure on this one

**Further explanation about Operators:**

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

  • So if the filter (the source) is using an operator that the category object (target) accepts, the value is kept

  • Otherwise the filter is ignored

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)the destination Category

In the following Bar chart example, we have a category that uses ‘Job Role’ as a Dimension. We’ve enabled ‘Drill to Category’ on this chart.

...

In our Destination Category, we have another Bar chart and this Category has a Category Object filter set up for ‘Job Role’.

...

When we click a Bar in our source category, the selected Job Role will be passed to the Category Object filter in the destination category and the chart in this category will be automatically filtered on the selected Job Role.

...