SUM(MAX() over (partition by))
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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 656 Automate
- 170 Apps
- 439 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive