AnsweredAssumed Answered

Time series charts

Question asked by mjroberson on May 15, 2013
Latest reply on May 15, 2013 by philmodjunk


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