7 Replies Latest reply on Oct 2, 2013 1:49 PM by . Indumon

# How to correlate two parts of the same measure?

e.g.

I have a list of genes and their levels for each of a few conditions

ConditionGeneAbundance
AG177
AG280
AG390

B

G110
BG120
BG330

How can i correlate the abundnance by gene between condition A and condition B?

I can do this if i add abundance columns for all the various conditions, but that's annoying.

Thanks!

• ###### 1. Re: How to correlate two parts of the same measure?

What kind of view do you want to build?

• ###### 2. Re: How to correlate two parts of the same measure?

I guess a correlation plot is not common nomenclature... sorry

I mean a scatter plot with the abundance in condition A on one axis v.s Abundance in condition B on the other (with gene on the detail shelf)

I have this working fine right now, with one file per condition - but it seem like it should be possible to do this all within a single table.

• ###### 3. Re: Re: How to correlate two parts of the same measure?

I managed to do it with a single data source.

It just needs a unique ID for each row, which I faked by adding a copy of Abundance measure to Detail.

• ###### 4. Re: How to correlate two parts of the same measure?

I guess I was not clear about the values... sorry - I'll try again. For this dataset there should be three points on the graph (one for each gene).

G1 at 10,77

G2 at 20,80

G3 at 30,90

I also tried to do this by copying the abundance measure, but i could not find a way to copy only part of the measure (the part with condition A)

• ###### 5. Re: Re: How to correlate two parts of the same measure?

I hope you are looking for the correlation of Genes in two different Conditions using a scatter plot as given below.

To achieve this output you have to split the Abundance measure into two, "Abundance A" and "Abundance B"

Step 1: Create Calculated fields for each of them

Abundance A= If [Condition]='A' then [Abundance] End

Abundance B= If [Condition]='B' then [Abundance] End

Step 2: Drag the "Abundance A" measure to Rows

Step 3: Drag the "Abundance B" measure to Columns

Step 4: Drag the dimension "Gene" to color shelf

Step 5: Drag measures "Abundance A" and " Abundance B" to Label shelf

Step 6: Format the Label->text property as in the screen below.

• ###### 6. Re: How to correlate two parts of the same measure?

Thanks!

I thought I tried that, but I must have has some other problem that kept me from getting it working - when i try it on a very simple workbook your method is exactly what I'm looking for.

Let's hope this scales to hundreds of thousands of points in each condition

Thanks again!