Setting up a chart filter

Before you can use a chart control, you must set up a chart filter for the chart control. Chart filters work as normal filters.

Setting up a chart filter is similar but you must take note of these settings:
  • The filter must return at least three columns, and they are indexed as 0, 1, 2, and so on. If more than 3 columns are returned, you can set a description label for each column. This will be shown in the chart as label. The indexes must be numeric.
  • In the WHERE clause, you can use these placeholders:
    Placeholder Value
    %C Account ID
    %L Language ID of the current user context
    %R CLM codes passed to the child filter
    %A Account number

    To enable a chart drill down, you must specify a child chart filter.