New York Guy
2009-03-28 19:30:54 UTC
I have a bar chart (two bars) where the x axis is the date of the week and the
y axis the quantity.
I have one cfchart tag and two cfchartseries tags inside. One is for organge
and the other is for apples.
The chart displays fine. What I need to do now is create a drilldown page for
each bar. If I click on the orange bar for a particular day, then I need to
display the detailed report behind that bar. If I click the bar for apple for a
particular day, then I need to display the detailed report behind that bar.
Since I only have one cfchart, the url to pass would be
reportname.cfm?date=$itemlabel$, but how would I know that the apple bar was
selected and pass apple, as opposed to orange bar, and pass the orange variable
?
Right now, my report displays the data for both organges and apples combined,
for the particualr day. I need to separate them based on which bar was selected.
y axis the quantity.
I have one cfchart tag and two cfchartseries tags inside. One is for organge
and the other is for apples.
The chart displays fine. What I need to do now is create a drilldown page for
each bar. If I click on the orange bar for a particular day, then I need to
display the detailed report behind that bar. If I click the bar for apple for a
particular day, then I need to display the detailed report behind that bar.
Since I only have one cfchart, the url to pass would be
reportname.cfm?date=$itemlabel$, but how would I know that the apple bar was
selected and pass apple, as opposed to orange bar, and pass the orange variable
?
Right now, my report displays the data for both organges and apples combined,
for the particualr day. I need to separate them based on which bar was selected.