Skip to main content
Inspiring
September 26, 2008
Question

QofQ Chart

  • September 26, 2008
  • 2 replies
  • 512 views
I have written a query of queries that returns the required results. From those results I find aggregates of the various data groupings being returned (these are stored in session variables).

What I need to do now is to use the aggregate results that exist in session variables to create a pie chart, but I have not found a way to do this. It seems I will necessarily have to save the information in a database and then use that information to create the chart.

I want to know if there is a way to just used the values in the session variables to create the chart. TIA
NB: parts of my code are attached

    This topic has been closed for replies.

    2 replies

    Inspiring
    September 26, 2008
    Google "coldfusion queryfunctions". You can create your own query and populate it with your session variables.
    Inspiring
    September 26, 2008
    Abdlah wrote:
    >
    > I want to know if there is a way to just used the values in the session
    > variables to create the chart. TIA
    >

    You would use <cfchartdata...> tags inside of a <cfchartseries...> block
    to define specific data points rather then using the <cfchartseries ...>
    valueColumn and itemColumn properties that get the data points from
    query columns.