AnsweredAssumed Answered

Creating a chart from a count

Question asked by DuaneJuell on Jun 13, 2012
Latest reply on Jun 13, 2012 by philmodjunk

Title

Creating a chart from a count

Post

I have a database that keeps track of incoming orders.  What I want to create is a line chart with the x axis a week date and y axis is the number of orders submitted that week.

I already have a table view with field Weekdate ( DateIn - DayofWeek) for each order and summary field EachWeekCount as a count of WeekDate.  This table works great.  It shows the week of 5/26/2012 had 18 orders and 6/2/2012 had 22. 

From there, I drew in a chart, made the x axis Weekdate and the y axis EachWeekCount.  Now the chart shows not 18 and 22 but a straight line across the chart at 1161- the running count of all the orders submitted.  What am I doing wrong?

Outcomes