Window Function KB article

jaeW_at_Onyx
jaeW_at_Onyx Coach
edited March 2024 in Beast Mode Ideas

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.

image.png

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"
Tagged:
9
Up
9 votes

In Review ยท Last Updated

Thanks for sharing your idea! We're currently reviewing it for future enhancements. Stay tuned for updates! ๐Ÿ‘

Comments

  • Domomon
    Domomon Member

    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.

    https://docs.aws.amazon.com/redshift/latest/dg/c_Window_functions.html


  • BSovers
    BSovers Member

    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!

Categories