MAX of SUM in Beast Mode Windowing Functions
Hello!
Our org just had our windowing functions for Beast Mode turned on, and we're hoping to utilize it to calculate our MAX messages per second. Below is the logic I've gotten so far, but it does not work unless the table has all of the fields in it. We want to display the value dynamically, so we need to stay within beastmode for this formula.
MAX(SUM(`TOTALMESSAGES`))
OVER(
PARTITION BY `MESSAGE_DATE`,`MSG_HOUR`,`MSG_MINUTE`,`MSG_SECOND`
ORDER BY `MESSAGE_DATE`,`MSG_HOUR`,`MSG_MINUTE`,`MSG_SECOND` ASC)
Thanks in advance!
Comments
-
By definition, you can only partition on columns that are part of the card , because those columns in the card become part of the query that extracts data from Domo.
To only retrieve one value, keep the Max(Sum ...) and add a data table limit set to 1.
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
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 726 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 302 仲間に相談
- 664 ひらめき共有