2 Replies Latest reply on Feb 14, 2007 8:06 AM by waz69

    Multiple charts from one query

    waz69
      I have a database containing demographic information for visitors to various sites. I would like to create a separate chart for each site summarizing its demographics. My SQL statement looks something like this:

      SELECT SITE, RACE, LANGUAGE, GENDER FROM VISITS GROUP BY SITE

      Can this be used to generate a series of charts, one for each site? About the only thing I have come up with is a loop using cfoutput's group option and cfchartdata to get individual data points and I don't think even that would work since I'm not sure how I can construct a loop to accomplish this. Thought I'd see if there was an alternative that I overlooked before I threw myself into it..