What kind of view do you want to build?
Thanks for your reply.
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.
Thanks again for your reply.
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)
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.
Abundance Scatter.twbx.zip 17.7 KB
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
Brad, When you bring in more data, many points will overlap each other and labels will not be visible for all points.
So I suggest to create a dynamic dashboard or use quick filters to make your report behavior dynamic and clear.