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
In your data source settings for the chart, make sure that you select the "found set", "Summary values when sorted" options.