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.