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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive