5 Replies Latest reply: Jul 30, 2013 5:22 AM by Jesper Juul RSS

    Parking lot, peak pr. day

      Dear sirs

       

      I administer a parking lot, and I wish to measure the max/min usage pr. day/hour etc.

      For now I have constructed a table that counts how many cars have parked in a certain time interval (15 mins)

       

      the formula for this is sum(count) and Period is the dimension

      Udklip.JPG

       

      So - I can measure the no of cars parked on any given time.

       

      Now i wish to create a chart that shows (with the date as the X-axis)

      - average no of parked cars in every 15 min interval throuhout the day

      - max of parked cars during the day (pr. 15 min interval)

      - min of parked cars during the day

       

      I have some trouble contruction the formulas for this. Can anyone throw a lifeline?

       

      Thanks in advance.

       

      Jesper