I've built a fairly simple app using CF9 to keep track of results for my track athletes (I teach HS CompSci and coach track). I'd like to compile results for an individual athlete's events into a scatter chart of time (or distance, for non-timed events) on the X axis and date on the Y axis so the athletes and coaches can visualize performance over time.
However, it looks like I can only scale the chart numerically and not via time...am I missing something? Is there a way to scale from, say 0:40 to 2:00 for an athlete running the 400m? I'm storing the values in a time data type field. I ended up doing a feet/inches workaround (I convert and store the values as inches in the database so that I can sort them properly) for throwing and jumping events by just rounding off to the nearest foot. Next, I'd like to be able to draw a line across the chart so that athletes can see how they are performing with relation to things like qualification times for regional and state meets. Is there a way to do this? Finally, is there any way to control the appearance of the point on a scatter chart? I'd like to make it more of a point than the small box that it is by default. Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
