1 Reply Latest reply on May 15, 2013 2:49 PM by philmodjunk

    Time series charts

    mjroberson

      Title

      Time series charts

      Post

            

           I am trying to create a report including charts that show the average water use by month by account.  I have the following fields;

            

           Account

           Month

           Year

           Use

           Monthly Use Average = average of monthly use by account

            

           I currently have a two column Report by Account that has Month (1-12) and Average use for each month.

            

           When I go to Quick Chart this data, the only thing I get is the annual average (i.e. the sum of all "averaged" months) by account.  I want the chart to look like the two columns of data i.e. Month as X-axis and Monthly Use Average as Y-axis.

            

           I would appreciate any guidance.  thanks