4 Replies Latest reply on Oct 29, 2018 1:21 PM by David Gibson

    How to associate an avg value to a set of specific dates

    David Gibson

      First Im a total NOOB.

       

      Here is the issue I have actions taking place over a course of time. Lets say Running....

       

      So Person X runs 1000 miles from March 1st to March 10th.

      Avg per day is 100 miles per day

       

      How do I associate

      March 1 with avg 100 miles and

      March 2 with avg 100 miles and

      March 3 with avg 100 miles ....

       

      Then repeat this process for person X year round and Person y,z,w

       

       

      My goal is to make a table showing

      Sum Total for each day of the month/quarter/year based each days average for all runners.