I’m having a transform table, and the objects loaded have a “numeric” field.
I want to compute the proportion for this property.
e.g. let’s assume 3 objects with property 10, 50, 100. Then I want a column to be computed with 0.1, 0.5 and 100.
As I don’t know the “max” boundary, I’m essentially doing @myCol / max(@mycol) but it seems I obtain ones (1) only so the division is an entire integer division ?
How can I compute this column while this being still a double ?
I believe the functions in a transform table numeric formula only apply to one row: It’s designed to take the max across multiple columns, not rows, eg max(@col1, @col2). In your case, max(@myCol) just returns @myCol, hence the 1.
You could create a distinct numeric aggregation board to compute the max of a given column, and then use the result in the table formula: @myCol / $maxAggregation
Yes the answer above is correct, the @col1 syntax refers to the the col1 value in the same row of the table, while $card_id refers to the value of another card in the analysis. Here’s an example of how to achieve the workflow described
