The following page describes all the settings that can be used in table placeholders in reporting templates. Placeholders for tables can include four different groups of settings. These are:
- “data” (required) – containing settings about table content, such as type of the table, and rows and columns that the table will contain,
- “display” (optional) – containing information about table display (e.g., number of significant digits to which the values in the table should be rounded, table direction, style, …
- “stratification” (optional) – containing information about table splitting and/or filtering,
- “renamings” (optional) – containing various words present in the data set or PKanalix that should be reworded in the table.
Settings inside these groups of settings need to be indented or put inside curly brackets. It is crucial to respect the indentation rules and the space after the “:” for the placeholder to be properly interpreted.
Data
Data settings define the type of the table that will be generated, as well as rows and columns that the table will contain. Here is the list of all settings of the data group of settings, along with their descriptions:
Setting | Table | Required |
Possible values | Description |
task | All | yes | be, ca, nca | Task of which the table represents the results. |
table | Points included for lambdaZ (NCA) Anova table (BE) Table of CVs (BE) Table of confidence intervals (BE) Cost table (CA) |
yes | pointsIncludedForLambdaZ, anova, coefficientsOfVariation, confidenceIntervals, cost | Table type. If empty, CA or NCA parameters table will be generated (depending on the task argument). |
formulation | Table of confidence intervals (BE) | no (default: all) | name of one of the test formulations present in the data set, or “all” | In case of confidenceIntervals table and multiple test formulations, setting can be used to select one of the non-reference formulations. |
metrics | Table of parameters (CA or NCA) | no | “all” or one or several of: ID, min, Q1, median, Q3, max, mean, SD, SE, CV, Ntot, Nobs, Nmiss, geoMean, geoSD, geoCV, harmMean | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Points included for lambdaZ (NCA) | no | “all” or one or several of: ID, time, concentration, BLQ, includedForLambdaZ | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Table of confidence intervals (BE) | no | “all” or one or several of: AdjustedMean, N, Difference, CIRawLower, CIRawUpper, Ratio, CILower, CIUpper, BE | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Coefficient of variation (BE) | no | “all” or one or several of: SD, CV | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Anova table (BE) | no | “all” or one or several of: DF, SUMSQ, MEANSQ, FVALUE, PR(>F) | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Cost table (CA) | no | “all” or one or several of: Cost, -2LL, AIC, BIC | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
excludedMetrics | All | no (default: none) | Same arguments as for metrics (except “all”). | Metrics that will be excluded from the table. Handy when a user wants to specify metrics: “all” and exclude a few with excludedMetrics. |
parameters | Table of parameters (CA/NCA) | no (default: all) | One or more of parameters calculated in NCA or CA, including Cost if CA, or “all”. | Parameters that will be included in the table. Used when table setting isn’t specified. |
excludedParameters | Table of parameters (CA/NCA) | no (default: none) | Same arguments as for parameters, excluding “all”. | Parameters that will be excluded from the table. Handy when a user wants to keep most of them. |
factors | Anova table (BE) | no (default: all) | One or more of the headers of columns used in the BE linear model, including Residuals, or “all”. | Factors included in the linear model. |
excludedFactors | Anova table (BE) | no (default: none) | Same arguments as for factors, excluding “all”. | Factors included in the linear model. |
ids | Table of parameters (CA/NCA) Points included for lambdaZ (NCA) |
no (default: all) | One or several of IDs present in the dataset, or “all”. | IDs of subjects whose parameters should be shown in the table. The summary statistics will be calculated on all individuals, not just ones shown in the table. If not present, default is “all”. |
excludedIds | Table of parameters (CA/NCA) Points included for lambdaZ (NCA) |
no (default: none) | Same arguments as for ids, excluding “all”. | IDs of subjects whose parameters should be excluded from the table. The summary statistics will be calculated on all individuals, not just ones shown in the table. |
nbOccDisplayed | Table of parameters (CA/NCA) Points included for lambdaZ (NCA) |
no (default: -1 meaning all) | -1 or an integer | -1 means all occasion levels are diplayed. 0 mean none of the occasion levels are diplayed. 1 means only the first occasion level is displayed, etc. |
covariates | Table of parameters (CA/NCA) | no (default: all) | One or more of covariates present in the data set, or “all”. | Which covariates to include in the table. |
covariatesAfterParameters | Table of parameters (CA/NCA) | no (default: true) | true, false | If covariates should be shown after parameters in the table. |
Data
Data settings define the type of the table that will be generated, as well as rows and columns that the table will contain. Here is the list of all settings of the data group of settings, along with their descriptions:
Setting | Table | Required |
Possible values | Description |
task | All | yes | be, ca, nca | Task of which the table represents the results. |
table | Points included for lambdaZ (NCA) Anova table (BE) Table of CVs (BE) Table of confidence intervals (BE) Cost table (CA) |
yes | pointsIncludedForLambdaZ, anova, coefficientsOfVariation, confidenceIntervals, cost | Table type. If empty, CA or NCA parameters table will be generated (depending on the task argument). |
formulation | Table of confidence intervals (BE) | no (default: all) | name of one of the test formulations present in the data set, or “all” | In case of confidenceIntervals table and multiple test formulations, setting can be used to select one of the non-reference formulations. |
metrics | Table of parameters (CA or NCA) | no | “all” or one or several of: ID, min, Q1, median, Q3, max, mean, SD, SE, CV, Ntot, Nobs, Nmiss, geoMean, geoSD, geoCV, harmMean | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Points included for lambdaZ (NCA) | no | “all” or one or several of: ID, time, concentration, BLQ, includedForLambdaZ | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Table of confidence intervals (BE) | no | “all” or one or several of: AdjustedMean, N, Difference, CIRawLower, CIRawUpper, Ratio, CILower, CIUpper, BE | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Coefficient of variation (BE) | no | “all” or one or several of: SD, CV | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Anova table (BE) | no | “all” or one or several of: DF, SUMSQ, MEANSQ, FVALUE, PR(>F) | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
metrics | Cost table (CA) | no | “all” or one or several of: Cost, -2LL, AIC, BIC | If equal to “all”, all available rows or columns will be present in the table. If specific metrics are given, only those rows/columns will be available in the table. |
excludedMetrics | All | no (default: none) | Same arguments as for metrics, excluding “all”. | Metrics that will be excluded from the table. Handy when a user wants to keep most of them. |
parameters | Table of parameters (CA/NCA) | no (default: all) | One or more of parameters calculated in NCA or CA, including Cost if CA, or “all”. | Parameters that will be included in the table. Used when table setting isn’t specified. |
excludedParameters | Table of parameters (CA/NCA) | no (default: none) | Same arguments as for parameters, excluding “all”. | Parameters that will be excluded from the table. Handy when a user wants to keep most of them. |
factors | Anova table (BE) | no (default: all) | One or more of the headers of columns used in the BE linear model, including Residuals, or “all”. | Factors included in the linear model. |
excludedFactors | Anova table (BE) | no (default: none) | Same arguments as for factors, excluding “all”. | Factors included in the linear model. |
ids | Table of parameters (CA/NCA) Points included for lambdaZ (NCA) |
no (default: all) | One or several of IDs present in the dataset, or “all”. | IDs of subjects whose parameters should be shown in the table. The summary statistics will be calculated on all individuals, not just ones shown in the table. If not present, default is “all”. |
excludedIds | Table of parameters (CA/NCA) Points included for lambdaZ (NCA) |
no (default: none) | Same arguments as for ids, excluding “all”. | IDs of subjects whose parameters should be excluded from the table. The summary statistics will be calculated on all individuals, not just ones shown in the table. |
covariates | Table of parameters (CA/NCA) | no (default: all) | One or more of covariates present in the data set, or “all”. | Which covariates to include in the table. |
covariatesAfterParameters | Table of parameters (CA/NCA) | no (default: true) | true, false | If covariates should be shown after parameters in the table. |
Display
Display group of settings defines how the information in the tables will be displayed. Here is the list of all settings for the display group of settings:
Setting | Table | Required | Possible values | Description | Example(s) |
units | Table of parameters (CA/NCA) Anova table (BE) Table of CVs (BE) Table of confidence intervals (BE) Cost table (CA) |
no (default: true) | true, false | If true, units will be output next to parameters. | units: true |
CDISCNames | Table of parameters (CA/NCA) Anova table (BE) Table of CVs (BE) Table of confidence intervals (BE) Cost table (CA) |
no (default: false) | true, false | If true, CDISC names of parameters will be shown in the table. | CDISCNames: true |
style | All | no (default: selected in Generate report pop-up) | Name of table styles present in the template document. | Microsoft Word document template style to apply to the table. This setting overrides the setting in the Generate report pop-up. | style: “Medium Grid 1 – Accent 1” |
metricsDirection | All | no (default: vertical) | vertical, horizontal | Direction of metrics. | metricsDirection: horizontal |
significantDigits | All | no (default: taken from Preferences) | positive integers | Number of significant digits values in the table will be rounded to. | signifcantDigits: 3 |
trailingZeros | All | no (default: taken from Preferences) | true, false | If trailing zeros should be shown in the tables. | trailingZeros: true |
inlineUnits | Table of parameters (CA/NCA) Anova table (BE) Table of CVs (BE) Table of confidence intervals (BE) Cost table (CA) |
no (default: true) | true, false | If units should be inline with parameters. If false, there will be a new line between a parameter name and a unit. | inlineUnits: false |
fitToContent | All | no (default: true) | true, false | If true, width of the table will be equal to the width of content, otherwise width of the table will be equal to the width of the page. | fitToContent: false |
caption | All | no (default: no caption) | a phrase inside quotation marks | Caption that will appear next to the table. | caption: “Individual NCA parameters” |
captionAbove | All | no (default: false) | true, false | If true, caption will be positioned above the table. If false, caption will be positioned below the table. | captionAbove: true |
fontSize | All | no (default: 12) | a number | Font size of the table content (will not be applied to the caption). | fontSize: 10 |
Stratification
Stratification group of settings defines how the table will be split. List of stratification settings:
Setting | Table | Required | Possible values | Description | Example(s) |
state | Table of parameters (CA/NCA) | no | Two possible subsettings: – split – can contain header names of covariates and/or occasions – filter – can contain header names of covariates and/or occasions and number(s) that describe alphabetical order of modalities |
Contains information of how to split the table. | state: {split: [FORM]} state: {split: [FORM, OCC]} state: {filter: [[FORM, [1]]]} state: {filter: [[SEQ, [1, 2]]]} state: {filter: [[FORM, [1]], [OCC, [1]]]} state: {split: [FORM, OCC], filter: [[OCC, [1]], [SEQ, [1]]]} |
splitDirection | Table of parameters (CA/NCA) | no | One or more of v, h | In which direction the table should be split. Number of arguments corresponds to number of covariates by which the table was split. | splitDirection: [v] splitDirection: [v, v] splitDirection: [v, h] |
Let’s take a look at the demo project project_crossover_bioequivalence.pkx. It contains data from a 2×2 crossover bioequivalence study of two controlled release formulations of theophylline. We would like to generate a placeholder for the summary table of NCA parameters and split it across sequences and formulations. If we select that we only want to compute Cmax and AUClast, here is how a default placeholder looks like when we click on the placeholder button next to the NCA summary table and which table it produces:
<lixoftPLH> data: task: nca metrics: [min, Q1, median, Q3, max, mean, SD, SE, CV, Ntot, Nobs, Nmiss, geoMean, geoSD, geoCV, harmMean] parameters: [AUClast, Cmax] display: units: true inlineUnits: true metricsDirection: horizontal significantDigits: 4 fitToContent: true </lixoftPLH>
min | Q1 | median | Q3 | max | mean | SD | SE | CV(%) | Ntot | N | Nmiss | GeoMean | GeoSD | GeoCV | HarmMean | |
AUC0-tlast (h⋅mg⋅L⁻¹) | 45.6709 | 116.8202 | 142.4099 | 179.027 | 236.6814 | 148.5547 | 46.7732 | 7.7955 | 31.4855 | 36 | 36 | 0 | 140.3561 | 1.4369 | 37.4696 | 130.4717 |
Cmax (mg⋅L⁻¹) | 3.56 | 6.12 | 8.76 | 9.94 | 11.53 | 8.1806 | 2.2192 | 0.3699 | 27.1282 | 36 | 36 | 0 | 7.8445 | 1.3597 | 31.4694 | 7.4633 |
If we want to split the table by the period and the formulation, we can select the appropriate checkboxes on the right and the default placeholder will change automatically. However, doing this always splits the table vertically. We can also remove some of the statistics that we want to exclude from the table by modifying the metrics argument.
<lixoftPLH> data: task: nca metrics: [min, median, max, mean, CV, Nobs, geoMean, geoCV] parameters: [AUClast, Cmax] display: units: true inlineUnits: true metricsDirection: horizontal significantDigits: 4 fitToContent: true stratification: state: {split: [FORM, Period]} splitDirection: [v, v] </lixoftPLH>
FORM | Period | Metrics | N | mean | CV(%) | GeoMean | GeoCV |
ref | 1 | AUC0-tlast (h⋅mg⋅L⁻¹) | 9 | 154.8982 | 26.3033 | 150.3623 | 26.1424 |
Cmax (mg⋅L⁻¹) | 9 | 9.82 | 11.8862 | 9.7571 | 12.1369 | ||
2 | AUC0-tlast (h⋅mg⋅L⁻¹) | 9 | 147.6183 | 36.178 | 137.7505 | 43.7537 | |
Cmax (mg⋅L⁻¹) | 9 | 8.3244 | 32.019 | 7.8713 | 39.0231 | ||
test | 1 | AUC0-tlast (h⋅mg⋅L⁻¹) | 9 | 133.3989 | 39.8426 | 122.3564 | 49.8543 |
Cmax (mg⋅L⁻¹) | 9 | 6.4689 | 28.8987 | 6.2384 | 29.1102 | ||
2 | AUC0-tlast (h⋅mg⋅L⁻¹) | 9 | 158.3035 | 26.9691 | 153.1323 | 28.1126 | |
Cmax (mg⋅L⁻¹) | 9 | 8.1089 | 22.1858 | 7.9035 | 25.4489 |
If we want to change the direction of splitting, for example, make a split by Period horizontal, instead of vertical, we can modify the splitDirection argument.
<lixoftPLH> data: task: nca metrics: [Nobs, mean, CV, geoMean, geoCV] parameters: [AUClast, Cmax] display: units: true inlineUnits: true metricsDirection: horizontal significantDigits: 4 fitToContent: true stratification: state: {split: [FORM, Period]} splitDirection: [v, h] </lixoftPLH>
Period | 1 | 2 | |||||||||
FORM | Metrics | N | mean | CV(%) | GeoMean | GeoCV | N | mean | CV(%) | GeoMean | GeoCV |
ref | AUC0-tlast (h⋅mg⋅L⁻¹) | 9 | 154.8982 | 26.3033 | 150.3623 | 26.1424 | 9 | 147.6183 | 36.178 | 137.7505 | 43.7537 |
Cmax (mg⋅L⁻¹) | 9 | 9.82 | 11.8862 | 9.7571 | 12.1369 | 9 | 8.3244 | 32.019 | 7.8713 | 39.0231 | |
test | AUC0-tlast (h⋅mg⋅L⁻¹) | 9 | 133.3989 | 39.8426 | 122.3564 | 49.8543 | 9 | 158.3035 | 26.9691 | 153.1323 | 28.1126 |
Cmax (mg⋅L⁻¹) | 9 | 6.4689 | 28.8987 | 6.2384 | 29.1102 | 9 | 8.1089 | 22.1858 | 7.9035 | 25.4489 |
Renamings
Renamings setting can be provided to the placeholder to replace certain words or expressions that will appear in the table with a user-defined word or expression. We will explain the usage of renamings setting on a concrete example.
Let’s take a look at the demo project project_parallel_absBioavailability.pkx. The project contains data from 18 subjects, of which 9 received an IV formulation of a certain drug and other 9 received an oral formulation. Let’s say we want to use the Bioequivalence feature of PKanalix to calculate bioavailability of the oral formulation and generate a report. It would be suitable to put a bioequivalence confidence intervals table in the report, with certain renamings.
A generated placeholder for a BE confidence intervals table, with its default settings, is shown below, including the table it generates.
<lixoftPLH> data: task: be table: confidenceIntervals metrics: [AdjustedMean, N, Difference, CIRawLower, CIRawUpper, Ratio, CILower, CIUpper, BE] parameters: [AUCINF_obs] display: units: true inlineUnits: true significantDigits: 4 fitToContent: true </lixoftPLH>
ORAL
Parameter | ORAL | IV | Bioequivalence | ||||||||
AdjustedMean | N | AdjustedMean | N | Difference | CIRawLower | CIRawUpper | Ratio | CILower | CIUpper | BE | |
AUC0-inf (h⋅ug⋅L⁻¹) | 223.9609 | 9 | 254.76 | 9 | -0.1289 | -0.2097 | -0.04805 | 87.9105 | 81.0865 | 95.3089 | yes |
Let’s say we would like to hide some of the columns and rename some of the expressions in the table. For example, it would be convient to rename “Bioequivalence” to “Absolute bioavailability”, “IV” to “intravenous”, “ORAL” to “oral formulation”, and “CILower” to “90% CI (lower)”. We can then modify the placeholder to look like the one on the left and it will generate the table on the right.
<lixoftPLH> data: task: be table: confidenceIntervals metrics: [AdjustedMean, N, Ratio, CILower, CIUpper] parameters: [AUCINF_obs] renamings: IV: "intravenous" ORAL: "oral formulation" Bioequivalence: "Absolute bioavailability" CILower: "90% CI (lower)" CIUpper: "90% CI (upper)" AdjustedMean: "Adjusted mean" </lixoftPLH>
Oral capsule
Parameter | Oral capsule | IV solution | Absolute bioavailability | ||||
Adjusted mean | N | Adjusted mean | N | Ratio | 90% CI (lower) | 90% CI (upper) | |
AUC0-inf | 223.9609 | 9 | 254.76 | 9 | 87.9105 | 81.0865 | 95.3089 |