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.

  4. In the Save as Derived Data modal window, under Name, type Pop, and click Save.

  5. Notice that in the left navigation under Measures, you have a 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.

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

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

You can now use Pop as any other measure.