Is there a way to calculate distance between two points without Studio or LookML, just an expression generated in Table Calculations? The user is pulling the location from a form.
Solved! Go to Solution.
Hey @Money_Honey !
There isn't a distance function in Looker table calculations, but you might be able to recreate the formula using our math functions. We have sine, cosine, and tangent, as well as power and square root. You could put them together in a formula like in this example: https://stackoverflow.com/questions/13026675/calculating-distance-between-two-points-latitude-longit...
Hey @Money_Honey !
There isn't a distance function in Looker table calculations, but you might be able to recreate the formula using our math functions. We have sine, cosine, and tangent, as well as power and square root. You could put them together in a formula like in this example: https://stackoverflow.com/questions/13026675/calculating-distance-between-two-points-latitude-longit...