AnsweredAssumed Answered

Time series charts

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

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

Outcomes