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 "accept" my answer as the solution
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 "accept" my answer as the solution
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive