Get value for first day of the month
I need to be able to create a beast mode that does the following: for any given month sum up columns A, B, and C, then get the value D for the first day of the month, and implement the following formula:
(SUM(A) + SUM(B)  SUM(C) / D for the first day of the month
I can do it in an ETL, but that involves aggregations and the Powers That Be want to be able to drill down to the underlying values. Is it possible to get value D in a Beast Mode?
Best Answers

I would use a dataflow but keep the data granular so drill downs are possible. I would just add a formula tile that for every row in the dataset gets the value from the first day of the month. Then the beastmode or calculated field in the ETL is really clean.
A + B + C / D
This would be the data structure and what they would see when drilling down ^
If I solved your problem, please select "yes" above
0
Answers

I would use a dataflow but keep the data granular so drill downs are possible. I would just add a formula tile that for every row in the dataset gets the value from the first day of the month. Then the beastmode or calculated field in the ETL is really clean.
A + B + C / D
This would be the data structure and what they would see when drilling down ^
If I solved your problem, please select "yes" above
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
 603 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 697 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
 386 Distribute
 111 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 8 Domo University
 30 Product Releases
 Community Forums
 40 Getting Started
 30 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive