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 =
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