Data Mappings panel

Mappings panels identify how input variables are to be used. Map the data by dragging the dataset from the Data folder to the Setup tab or use the icon_select_source icon in the Setup tab.

Once a dataset is mapped, use the option buttons in the Mappings panels to assign the columns in the dataset to the appropriate context associations. Required context mappings are colored orange.

None: Columns mapped to this context are not included in any analysis or output.

X: The independent variable axis. Note that, for Bar plots, this axis is the vertical axis. A single X mapping is required for Column, Bar, XY, and X-Categorical XY plots.

Y: The dependent variable axis. A single Y mapping is required for Box and QQ plots. Mapping of either Y or Y2 is also required for XY, X-Categorical XY, Bar, and Column plots.

Y2: The secondary dependent variable axis. This axis is displayed at the top of each plot.

Included: Variables used to create a Scatter Plot. At least two variables must be mapped to this context.

Data Label: Labels for data points on the X axis.

Distribution: Variable used to create the Histogram plot quartiles. A single Distribution mapping is required.

Group: Only for Bar, Column, Box, and XY plots. Groups the X axis based on the selected variable.

Grouping: Only for X-Categorical XY plots.

None: Data types mapped to this context are not grouped.

Grouping Group: Displays the data points using different data point markers based on the variable mapped to this context. Any data type in a dataset can be mapped to Group even if it is also mapped to the independent and dependent variables contexts.

Lattice Conditions:

Row: Separates the plots into multiple rows based on the selected variable or variables. Not available for Scatter Plots.

Column: Separates the plots into multiple columns based on the selected variable or variables. Not available for Scatter Plots.

Page (Sort): Separates the plot by page based on the selected variable. Allows sorting of plots by a variable(s). (See the “More on latticed plots in Phoenix” section.)

Error Bars: Error bars represent the overall distribution of the data and are used to indicate how closely the means of the data reflect the true values. Error bars are only available for XY, and X-Categorical XY plots, and for Column plots that have no Group mapping. (See the “Set up error bars” section.)

Lower Error Bar: Error bar lengths or coordinates down the Y-axis.

Upper Error Bar: Error bar lengths or coordinates up the Y-axis. Different variables in a dataset can be mapped separately to the Lower and Upper Error Bar contexts.

More on latticed plots in Phoenix

Latticing data is a way of arranging a plot display based on a sort key. For example, if a dataset contains columns for subjects, time of dose, and concentration, it is possible to create a graph that displays time versus concentration for each subject, if subject is mapped to Page (Sort) in the Mappings panel.

There are two ways to arrange a latticed graph: by row and by column. If a graph is latticed by subject, and there are three subjects in the dataset, Phoenix can create three graphs on one page that are displayed as either three rows or three columns.

Lattice conditions

Variables mapped to Lattice Conditions Row create a single column of plots in the Results tab.

For example, if a dataset contains 10 subjects and the subject variable is mapped to Lattice Conditions Row, then a column of 10 rows (one row per subject) with a separate plot in each row is created in the Results tab.

Variables mapped to Lattice Conditions Column create a single row of plots in the Results tab.

For example, if a dataset contains 10 subjects and the subject variable is mapped to Lattice Conditions Column, then a row of 10 columns (one column per subject) with a separate plot in each column is created in the Results tab.

Variables mapped to Lattice Conditions Page (Sort) create a separate plot per page in the Results tab. Each page is located on its own tab in the Results tab.

For example, if a dataset contains 10 subjects and the subject variable is mapped to Lattice Conditions Page (Sort), then 10 separate plots are created on 10 separate page tabs in the Results tab.

Lattice Titles panel usage

If a variable in a dataset is mapped to any of the Lattice Conditions, then the Lattice Titles panel is displayed in the Setup tab list. Map a worksheet to the Lattice Titles panel to add titles to the variable mapped to a Lattice Condition.

Import a worksheet that contains the titles associated with the variable or variables mapped to a lattice condition.

If titles are stored in a separate worksheet from the data source for the plots, that worksheet must contain the data that are used as the sort key(s) for the latticing, as well as one column that contains the title for the latticing sort keys.

Use the pointer to drag the worksheet from the Data folder to the Lattice Titles panel.

If the worksheet mapped to the plot Data Mappings panel contains the title column, drag the same worksheet to the Lattice Titles panel.

If using a separate worksheet for titles, match the Lattice Condition settings with those in the Data Mappings panel.

Select the Title option button to map the title column to the Title context.

Scatter Plot Matrix objects do not have a Lattice Titles panel


Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.