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

  • Chronos
    Chronos βšͺ️

    Is anyone able to help out with this request?

  • 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!

  • 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.Β