Chapter 7: (Interactive) Graphics for Biomarker Assessment by Michael Merz

Guidance for the creation of the figures using Spotfire.

Figure 1

Visualization type: tree map

Properties:

Colors: by average of relative change from baseline,

minimum green, median yellow, maximum red.

Size: UniqueCount(Subject-ID)

Hierarchy: Compound-Study-Treatment group

Figure 3

Visualization type: bar chart

Properties:

x-axis: value

y-axis: UniqueCount(Subject-ID)

Trellis: rows: treatment; columns: parameter

Colors: by gender

Lines & Curves: vertical lines: Avg(X), Avg(x)-StdDev(X), Avg(x)+StdDev(X)

Figure 4

Visualization type: bar chart

Properties:

x-axis: value class

y-axis: Max(Incidence per value class)

Trellis: rows: treatment; columns: parameter

Figure 5

Visualization type: bar chart

Properties:

x-axis: value class

y-axis: Max(Incidence per value class)

Trellis: columns: parameter

Colors: by treatment

Figure 6

Visualization type: scatter plot

Properties:

x-axis: baseline value

y-axis: maximum post baseline value

Trellis: rows: treatment; columns: parameter

Colors: by gender

Lines & Curves: vertical lines: straight line, value=ULN, value = 3 x ULN

horizontal lines: straight line, value=ULN, value = 3 x ULN

curve draw: x=y

Figure 7

Visualization type: box plot

Properties:

x-axis: treatment group

y-axis: maximum change from baseline

Trellis: columns: parameter

Statistics table: Unique count, outliers

Figure 8

Visualization type: scatter plot

Properties:

x-axis: value parameter 1, log scale

y-axis: value parameter 2, log scale

Trellis: panels: treatment

Colors: by gender

Lines & Curves: vertical line: straight line, value = 3 x ULN

horizontal lines: straight line, value = 2 x ULN

Figure 9

Visualization type: scatter plot

Properties:

x-axis: value parameter 1, log scale

y-axis: value parameter 2, log scale

Trellis: panels: treatment

Colors: by peak sequence (flag set via calculated column)

Shape: by relevance (flag set via calculated column)

Size: by 1/time interval between peaks (calculated column)

Lines & Curves: vertical line: straight line, value = 3 x ULN

horizontal lines: straight line, value = 2 x ULN

Figures 10-13

Visualization type: scatter plot

Properties:

x-axis: value parameter 1

y-axis: value parameter 2

Colors: by treatment

Lines & Curves: vertical lines: straight line, value=ULN, value = 3 x ULN

horizontal lines: straight line, value=ULN, value = 3 x ULN

curve draw: x=y

Figure 14

Visualization type: line chart

Properties:

x-axis: days post baseline

y-axis: value (parameter selected via filter panel)

Colors: by parameter

Trellis: panels by subject-ID

Lines & Curves: vertical line: line from data table, value=last treatment day

horizontal line: straight line, value=ULN

Figure 15

Visualization type: line chart

Properties:

x-axis: days post baseline

y-axis: value (parameters selected via filter panel)

Colors: by parameter

Trellis: panels by subject-ID

Lines & Curves: vertical line: line from data table, value=last treatment day

horizontal lines: straight line, value=ULN, value=3xULN

Figure 16

Visualization type: four line charts, each displaying one parameter (source table pivot by parameter)

Properties:

x-axis: days post baseline

y-axis: value

Colors: by treatment

Lines & Curves: horizontal lines: straight line, value=ULN, value=2xULN, value=3xULN

Figures 17-18

Visualization type: three plots: line chart plus two scatter plots, x-axes synchronized (custom plug-in). All with data limited by marking. Underlying tables linked to each other.

Properties:

Line chart:

x-axis: days post baseline

y-axis: value

Lines & Curves: horizontal line: straight line, value=3xULN

vertical lines: straight line, value=0 (baseline day); line from data table, values=visits

Scatter plot 1

x-axis: days post baseline

y-axis: comed name

Line connection: comed number

Shape: StartEnd type (start or end of comedication)

Lines & Curves: vertical lines: straight line, value=0 (baseline day); line from data table, values=visits

Scatter plot 2

x-axis: days post baseline

y-axis: adverse event term

Line connection: adverse event number

Shape: StartEnd type (start or end of adverse event)

Lines & Curves: vertical lines: straight line, value=0 (baseline day); line from data table, values=visits

Figure 19

Visualization type: tree map

Properties:

Colors: by average of maximum post baseline values, minimum green,

median yellow, maximum red.

Size: UniqueCount(Subject-ID)

Hierarchy: Compound-Study-Treatment group