0 Replies Latest reply on Nov 20, 2006 8:08 AM by score1

    Charts

    score1
      I have a chart that picks out the top ten performers. I have a URL added to it so taht when you click on the chart it takes you to the .cfm with an A to Z list of names.

      I want to be able to have it so that when you click on an individual segment of the pie chart it goes direct to the person clicked on instead of a list of names.

      Query is as follows:

      SELECT distinct pps_principals.name AS principals_name,
      COUNT(*) AS coursecount
      FROM (PPS_SCOS JOIN PPS_TRANSCRIPTS ON PPS_SCOS.SCO_ID = PPS_TRANSCRIPTS.SCO_ID)
      JOIN PPS_PRINCIPALS ON PPS_TRANSCRIPTS.PRINCIPAL_ID = PPS_PRINCIPALS.PRINCIPAL_ID AND PPS_TRANSCRIPTS.STATUS like '[P]'
      AND PPS_TRANSCRIPTS.TICKET not like 'l-%'
      and pps_scos.name like 'MT%'
      GROUP BY pps_principals.name
      ORDER BY coursecount desc

      The chart info is as follows:

      <cfchart chartwidth="450"
      chartheight="450"
      pieslicestyle="solid"
      show3d="yes"
      xoffset="0.1"
      yoffset=".2"
      fontsize="12"
      url="a_to_z.cfm?name=$itemlabel$">