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

    Calculate daily average




      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.