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
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 114 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 770 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 76 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive