1 Reply Latest reply on Sep 26, 2016 12:20 PM by Patrick A Van Der Hyde

    Calculate daily average

    pavan.reddy.4

      Hello,

       

      I have water usage records from several months of the year broken down per day and also have a list of active residents who use water per day. I would like to present a trend-line of the data Average data usage per day over the several months.

       

      For this, i understand would need to create a calculated field. Can someone provide help on how i can create the calculated field for display.

       

      Also, how i can i change from Avg to using Median and Mode for display.