By log2 you mean logarithm to base 2, rather than to base e or 10?
constant^ can be done by adding a new column containing the constant first, but obviously that is rather clunky. I guess we could allow value 1 to be a constant, instead of a column. Possibly also build in some common constants. e.g. extra field:
Value 1 type: column / constant* / e / pi
*=user supplies value in extra field.
I’m not sure what other constants would be useful.
I will give it some thought.
What sort of transformation are you doing that requires extensive use of logs and exponents? And why log2?
Yes I mean logarithm base 2 or a binary logarithm.
I use it in bioinformatic analysis.
Doubling rate can be described by a log ratio of 1, a halving rate can be described by a log ratio of −1, and an unchanged expression rate can be described by a log ratio of 0.
I will add log2() to the wishlist.
This will be in the next release.