Location Calculation without Studio or LookML

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 Solved
0 1 39
1 ACCEPTED 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...

 

View solution in original post

1 REPLY 1

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...

 

Top Labels in this Space
Top Solution Authors