Skip navigation
faym
faym Calculating status...
Currently Being Moderated

cfchart CFmx8 charting points with no data

Dec 27, 2007 7:04 PM


We are having a problem with <cfchart> in CF 8. It worked fine in CF7.02 with all hotfixes installed. Basically it plots points where there is no data. some lines have data for 15 points and some for maybe only 13 or 14 points. It fills in teh missing points with data from the last point that had data.

Notice the last three lines on this chart. At the end of the line--- where the line goes straight across it is charting data that doesn't exist.
http://www.bikersites.com/SL/raceSL/secondsbehind.cfm?RHID=31:1
This gets to be a real problem when you look at the following chart. It gives the races lap times for laps they never completed.
http://www.bikersites.com/SL/raceSL/laptimes.cfm?RHID=31:1

Any ideas? Anyone else having this problem?
This works fine on our development server which had CF7. But at hostmysite they have cf8.
182 Views   2 Replies   Latest reply: Gary1, May 8, 2012 10:49 AM
 
Replies
  • morecarl
    Currently Being Moderated
    1. morecarl,
    Jan 7, 2008 12:17 PM   in reply to faym
    Report
    I am having the same issue. In my case, I am using stacked bar charts and it is plotting values for series items that do not have any data.

    I had to force my sql to generate a 0 for series items that did not have value in order to get the chart to display correctly.
     
    |
    Mark as:
  • Gary1
    Currently Being Moderated
    2. Gary1,
    May 8, 2012 10:49 AM   in reply to morecarl
    Report

    Having same problem here, with CF9.  I have 5 monthly data points for Jan-May 2012.  But CFCHART will extend the LINE in the line chart for the June - December 2012 with all ZEROs.  This only happens when I'm plotting multiple series, for example if I add a CFCHARTSERIES for all 12 months in 2011. 

     

    If I remove 2011, CFCHART only displays the 5 monthly data points for 2012.  I'm using two CFQUERIES (Q of Q), one with 12 monthly data points for 2011, and one with 5 data points for 2012 year-to-date.  Individually (with 1 CFCHARTSERIES) they plot fine.  But when you have TWO CFCHARTSERIES, the 2012 extends the 2012 line with all ZEROs for June-Dec 2012.  So you don't get a good year-over-year chart, and I need one that scales, since all the values are between 90% and 100%.  Thanks for any help/advice.

     

    Gary

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)