Modifying Filters

The drop-down box in the Limits Dashboard section of Sample1mod.bqy displays three Territory options and a pie chart of total unit sales. Continuing from the previous exercises, the exercises in this section change the drop-down script so the user’s selection modifies the Limit line in the Limits Results section instead of displaying an alert. When the Limits Results section recalculates, the pie chart shows data for the selected Territory.

Study the JavaScript below. The basic steps to modify an existing limit are:

  1. Remove the existing value.

  2. Add a value.

  3. Assign a “limit operator”.

  4. Recalculate (results and tables), or Process (queries).

Image shows script in the Script Editor.