Chart for average sale by day of week in FM11
I've got a rather simple table with daily entires of gross sales and would like to make a bar chart that shows the days of the week and the average sales for each day. Defining the record set to a particular range of dates would then show the average sales in that time period on each day of the week.
I can get the correct numbers in summary fields but am having a logic meltdown on how to make the chart. Any thoughts?
Thanks - JohnH