2 Replies Latest reply on Oct 10, 2018 6:21 PM by Alex Martino

    How to calculate daily average

    Alex Martino

      Hello. I've attached a spreadsheet.

       

      How can I calculate the DAILY average? In the "real" data set, there might be days that don't show up. I want the average to still use those days (I have only a few days in this current example but in my real set there will always be 30 days)

       

       

      Also, I will have category #1 and category #2, so I will want to calculate this daily average

       

      When I calculate average now it just says "1" which isn't correct.