Partition in Beastmode or Possible Another Solution

Hi,
I have a dataset that joins spends from our Facebook account by date with leads that came in that day. Since we have multiple leads per day the "Facebook Spend By Day" will be in the data set multiple times.
In a beast mode I want to get a look at the total Facebook spend all time. I am using this right now: SUM(DISTINCT `Facebook Spent By Day`), but I know if there is an amount spent that is the same as another from a different day, then it won't be counted each time. I tried to do a partition by date like this: SUM(DISTINCT `Facebook Spent By Date`) OVER (PARTITION BY `Date`) but that isn't working the number much higher than it should. does anyone have an idea of how to fix this?
Best Answer
-
You want to use a FIXED function.
SUM(MAX(`Facebook Spend By Day`) FIXED (BY `Date`))
Was this comment helpful? Click Agree or Like below.
Did this comment solve your problem? Accept it as the solution!0
Answers
-
You want to use a FIXED function.
SUM(MAX(`Facebook Spend By Day`) FIXED (BY `Date`))
Was this comment helpful? Click Agree or Like below.
Did this comment solve your problem? Accept it as the solution!0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive