SUM(MAX() over (partition by))

lb1234

For this dataset used, I have a list of appointments scheduled, there are closers tied to individual appointments and the closer's weekly scheduled appointment limit. So, where the user is showing for multiple appointments, their weekly scheduled appointment limit is repeated on those lines.

The card I'm trying to create is summing up the teams total scheduled appointments for the week and subtracting that from their closer's cumulative max(weekly appointment limit.) This is the beastmode I thought would work but unfortunately, I'm having issues:

SUM(MAX(`Closer.WeeklyCloseApptLimit`) OVER (PARTITION BY CLOSER.ID)) - COUNT(DISTINCT `Opportunity ID`)

Any suggestions?

CFike

Hi have you seen the Beast Mode FIXED functions : https://domo-support.domo.com/s/article/4408174643607?language=en_US Check these options out and see if they fir your use case. Thanks