Addin custom math functions that take parameters to a Glide column

Ask for Help
1

I’m trying to create a scoring function for raw data (column entries), but I need to pass the raw data through a function to transform the values, specifically I want to use a logistic function: Logistic function - Wikipedia

Is there a way for me to achieve this using Glide (maybe using a fancy cell trick)?

2

Are all parameters of the Logistic function available to you from the raw data? I assume you can do it with the right math column set up.

3

Yeah, the logistic curve basically just takes one variable – the challenge is really how do I represent the function (especially since I have to use e) and get it to be reusable for various values in glide

4

https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column

You can see all the supported calculations for the math column here.

5

Thanks @ThinhDinh ! Do you think I’d be able to use the LOG function to represent e ?

6

It would be nice if Glide natively supported e the way that excel does

7

Have you been able to solve this? I’m not entirely sure it will work, just provided you with the functions that are currently supported by Glide.

8

Haven’t yet, thinking about spinning up a microservice to do the calculations so that I can have the full range of math expressions we need to get our result

1 Like