Defining Derived Data

To define Derived Data, follow these steps.

  1. Inside a visual that generates a subset of data, select a measure field on a shelf.

    In this case, we are using sum(population).

  2. Click the icon to the right of the field.

    field options when on shelf
    Accessing Field Options
  3. In the dropdown, click Save as Derived Data.

    clicking to save the derived data
  4. In the Save as Derived Data modal window, under Name, type Pop, and click Save.

    entering the name of the derived data and clicking saving
  5. Notice that in the left navigation under Measures, you have a new category Derived Data that contains Pop.

    viewing the new category Derived Data that contains Pop
  6. To check the definition of the saved derived data Pop, click the down arrow to the right of its name, and click View Definition.

    checking the definition of the derived data
  7. The Derived Data Definition modal window appears. Note that the definition includes a parameterized filter for year.

    viewing the filter year
  8. Click Save to save both the visual and the new derived data definitions.

You can now use Pop as any other measure.