Connect means for boxplots

firespot — Thu, 15 Mar 2012 19:51:12 GMT

Hi,

is there any possibility in SPOTFIRE to connect the reference points (mean, median, avg etc.) for boxplots?

Thanks in advance for inputs,

firespot

Transpose

Christof — Fri, 06 Aug 2010 17:39:30 GMT

Hi,

in Excel you can easily transpose a dataset by copying and paste/transpose it.

In Spotfire it works like this:

Add Data Table (from Clipboard)

Add an Unpivot data transformation and the directly add another Pivot data transformation, that's it.

Example:

For a dataset like this,

Person,test1,test2,test3
a,29,61,331
b,26,81,842
c,13,56,203
d,5,42,292
e,33,30,459

you will need to do the following:

1. Select File > Add Data Tables...
    Source data loaded from clipboard.
    Add the transformations:
        a. Unpivot
            Add columns to pass through:
                Person
            Add columns to transform:
                test1
                test2
                test3
            Category column name: Category
            Select category column data type: String
            Value column name: Value
            Select value column data type: Integer
            Select 'Include null values'
        b. Pivot
            Choose row identifiers:
                Category
            Choose value columns and aggregation methods:
                Sum(Value)
            Choose column titles:
                Person
            Column naming pattern: %C

Christof

Search results matching tag 'transpose'

Connect means for boxplots

Transpose