Window functions - Amazon Redshift
https://docs.aws.amazon.com/redshift/latest/dg/c_Window_functions.htmlCreate analytic business queries more efficiently using the window functions for SQL that Amazon Redshift supports.
Beast Mode Ideas
Beast Mode Ideas
Window Function KB article
jaeW_at_Onyx
Coach 
Domo does not appear to have a KB article for window functions despite having one for (newer) Fixed Functions.
It would be nice to have both.
Additionally it would be ideal if the Functions list in Beast Mode editor included all the available functions including window functions or statistical functions (MEDIAN() ) once the feature is enabled.
Lastly b/c the functions list can be impacted by features, it would be ideal if the added functions were included in the bootstrap api since that appears to be the best place to collect information about your instance config.
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"
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"
Tagged:
9
Comments
-
I heavily agree. I'm currently running into issues using some of the fixed functions and want to see if the window functions would address them, but you all only seem to point to the Amazon documentation.
1 -
I completely agree. Domo needs documentation! the bit of FUNCTION DESCRIPTION available in the Formula Editor is a joke. And searching by function name does not even give useful results.
Try searching for a complete description of the DATE_FORMAT, DATE_TRUNC, or TIMESTAMP_TRUNC functions, and you get thousands of results, with nothing near the top of any use!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive