Calculating the average per day for a summary figure
I'm new to Beast Mode and have a problem I could use some help with. I've scanned through the docs, built a few simple Beast Modes and watched a few of the introductory videos. Put another way, I have no clue what I'm doing
Comments
-
Is anyone able to help out with this request?
0 -
Hello DataSquirrel,
Please give the following Beast Mode a try and let me know how it goes. This assumes that "AssemblyDate" is a Date type field:
SUM(`PartsCount`)
/
COUNT(DISTINCT `AssemblyDate`)If this presents an error in your card, please let me know what it is so we can investigate in more detail. Thank you!
Darius Rose
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thanks a lot for the answer. I played around with using COUNT(DISTINCT... and some other operations. I can see how this can help out, for sure.
Stepping back out from Beast Mode for a second, is it smarter to pre-process a lot of these summaries instead? For example, if I want to chart comparisons of worker productivity, I can pre-calculate their daily average for days they worked. (Or, better, an average by minute.) I guess I would add columns to my input with the same average value for a specific worker in every row.
I'm a database person...so it's proving a bit of a struggle for me to think properly about composing easily chartable data sets. With databases, an extra column is almost never the solution, but with Domo it seems like an extra column, or extra name-value pairs, are almost always a good idea. Any comments from people coming from databases to Domo would be much appreciated, but not just them...just copping to a bias/flaw in my habitual thinking.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive