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
Presumably, you have a calculation field that identifies the week that a given daily entry is part of.
You'd place your chart in the body--not a subsummary part, specify "show data points for groups of records when sorted" and sort your records on just that one "week" calculation field.
Are you able to get that to work for you?