Help with editing code that uses Filter allow
Hi there:
BACKGROUND:
I have data is a list of grants with organization name, grant amount, status of grant.
I have Beast Mode code:
SUM(SUM(requests_amount_recommended
) FIXED (BY organizations_id
FILTER ALLOW requests_granted
))
I think it works - the issue is that it is summing TOO much. Ideally, I want to edit this code so that requests_granted IS TRUE
or another way
not use "requests_granted" and instead use requests_state is "granted" or "closed"
Anybody know how to write that?
Answers
-
I'm guessing when you say "summing too much" you are referring to the fact that it's aggregating across the entire range, and not that the total value is incorrect.
Are you saying that you only want to sum when the request_granted is True or request_state is 'granted' or 'closed'?
If you are saying that you want to subset the total to be split by requests_granted true and false, you can add another layer to the BY portion of your fixed statement.
SUM(SUM(requests_amount_recommended) FIXED (BY organizations_id,requests_granted FILTER ALLOW requests_granted))
If this doesn't answer your question, please provide some example data, as well as a mock-up of your desired output/behavior.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0 -
The answer to your question below is YES - I'd like either or:
Are you saying that you only want to sum when the request_granted is True OR request_state is 'granted' or 'closed'?
Ideally, I like to sum grants by org where the request_state granted' or 'closed' — I believe that is the cleanest.
0
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
- 688 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 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
- 112 Manage
- 109 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