Trigonometric Functions in Beastmode
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.
Comments
-
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
try out your trig functions in beast modes, some of them aren't documented.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Would love to hear more from @MichelleH
We tried Trig Functions in Beast Mode and they do not work, only in ETL.
0 -
@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
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@JenniferGibson , @jaeW_at_Onyx is correct. Currently Redshift and Python are the methods where we've had success with location matching.
0 -
+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.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive