SUM(MAX() over (partition by))
Options
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?
0
Answers
-
Hi have you seen the Beast Mode FIXED functions :
Check these options out and see if they fir your use case. Thanks0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 569 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.4K Charting
- 601 Beast Mode
- 15 App Studio
- 29 Variables
- 600 Automate
- 151 Apps
- 418 APIs & Domo Developer
- 29 Workflows
- 2 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 362 Distribute
- 99 Domo Everywhere
- 261 Scheduled Reports
- 2 Software Integrations
- 98 Manage
- 95 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive