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

    Time series charts



      Time series charts



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






           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