CODEWITHSUNDEEP
calculated-columnsspotfiretibcospotfire-analyst
Antonio Volpini
Antonio Volpini

Reputation: 11

Spotfire Dense rank sorting via custom expression

I am working with a dataset in Spotfire that has several replicates of multiple test articles being run through several sets of conditions, with a single final readout column. i.e. Example Table

In this example I am trying to rank my results to make the end graphs more digestible. I started with limiting the data set to only the conditions that I want through the "Limit Data through a custom expression" panel. Then set up a denserank function in a custom expression on the x axis to sort the values into a smooth curve. The expression I am trying is:

DenseRank(Avg([Lum/OD]) OVER ([MOLECULE_ID]), "asc") which results in the following graph: Graph Here

Could anyone explain why the displayed data doesn't rank in an ascending curve? I'm sure I'm missing something with how the custom expression is applied, but I don't see what.

Upvotes: 0

Views: 771

Answers (1)

Gaia Paolini
Gaia Paolini

Reputation: 1462

Could you try the Y axis as

Avg([Lum/OD]) over ([MOLECULE_ID])

Avg([Lum/OD]) by itself using your sample data lines up all markers to the same level, so I am not sure what happens in the graph you showed - where the markers are at different heights. The Y axis looks like a label in your graph, what was the underlying expression?

Upvotes: 0

Related Questions