Search Knowledge Base by Keyword

Secondary Filter

< Back

Secondary filters are used to apply multiple filter options to a chart. In the example below, we are creating a pie chart to represent New York Computers by Operating System. Operating System is the first filter applied to the Computer data type. To filter on only Computers in New York, we apply a secondary filter.

From the Charts tab, you can create a chart with a secondary filter. To create:

  1. Click the New Chart button to bring up the New Chart wizard
  2. Enter the properties of the new chart

    1. Name – New York Computers by Operating System
    2. Source Type – Data Type
    3. Source Table – Primary: Computer
    4. Description – This field was left blank
    5. Chart Type – Pie
    6. Heading Color – Red
    7. Chart Span – Half Width
    8. Chart Position – After: Migrated Computers by Location
    9. Results to Show – All
    10. Show Zero Values – NO. This will omit all zero values from the chart legend.
    11. Show by Default – YES
    12. Display Percentage In Legend – YES. This will display percentages in the chart legend.
    13. Display First Legend Item Percentage In Chart – NO
    14. Enabled – YES
  3. Select the data columns and filters of the new chart

    1. Data Column – Operating System
      1. Filter – None selected. This will display all Operating System values on the chart.
      2. Label – The label was left blank. The field is ignored unless one or more filter values are selected.
      3. Color – Black. The field is ignored unless one or more filter values is selected.
    2. Secondary Filter
      1. Column Name – Location
      2. Filter – New York. Use the field to filter the data displayed on the chart to the selected Locations.
  4. Click the Preview Chart button to preview the chart before saving. Click the Close button to exit the chart preview.
  5. Click the Create Chart button when finished to create the chart. You will be redirected back to the Charts tab. Click the Cancel button to cancel the operation.
  6. The New York Computers by Operating System area chart is shown below:
Tags: