Question
cfchart question
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.
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.
AdChoices