1 Reply Latest reply on Aug 9, 2010 10:01 AM by philmodjunk

    Chart for average sale by day of week in FM11

    ntsmedia

      Title

      Chart for average sale by day of week in FM11

      Post

      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