Trigonometric Functions in Beastmode

JenniferGibson

We are trying to find a viable way to be able to enter a variable (zip code) and locate all records that are within a given radius distance of the zip code. This requires trig functions as well as variables. We are utilizing the beta variables version and trying to build this out. We have discovered that trigonometric functions are available in Magic ETL, but not in Beast Mode. In order for this to work, we'd need it in Beast Mode so that we could apply the function to the variable.

jaeW_at_Onyx

at the domo user conference @MichelleH showed how she used redshift + geometry functions to get that done.

https://docs.aws.amazon.com/redshift/latest/dg/ST_Point-function.html

https://docs.aws.amazon.com/redshift/latest/dg/ST_DistanceSphere-function.html

try out your trig functions in beast modes, some of them aren't documented.

JenniferGibson

Would love to hear more from @MichelleH

We tried Trig Functions in Beast Mode and they do not work, only in ETL.

jaeW_at_Onyx

@JenniferGibson , @MichelleH used Redshift not Magic to get the job done.

Beast Modes run on Adrenaline (Domo's database layer), Magic runs in a different environment. Even though many of the functions use similar syntax there is not always 1:1 parity in implemented functions, AND they are not processed in the same space.

If you've got Python, you can follow this tutorial. https://www.youtube.com/watch?v=vkPINf41GIE&t=1s

MichelleH

@JenniferGibson , @jaeW_at_Onyx is correct. Currently Redshift and Python are the methods where we've had success with location matching.

chapman

+1 for this. Would love to be able to pass a variable into a beast mode with trig functions to calculate a list of stores within X radius.