MAX of SUM in Beast Mode Windowing Functions
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.
PARTITION BY `MESSAGE_DATE`,`MSG_HOUR`,`MSG_MINUTE`,`MSG_SECOND`
ORDER BY `MESSAGE_DATE`,`MSG_HOUR`,`MSG_MINUTE`,`MSG_SECOND` ASC)
Thanks in advance!