I am also using fusion charts with dot net nuke.
I am not able to produce a multilevel drill stacked chart. I am trying to populate all the required values using subqueries.
The html code below was pasted in the 'default item no query' box. The main stacked chart works if i comment from <linkeddata id='[jobid]-dd'> to </linkeddata> but otherwise displays nothing. Please let me know if it is even possible and if possible then how it is to be done. Need help immediately. Thanks.
Basically, one job has multiple issues under resolved or pending. By clicking on the column, I want to view the issues for employees under that particular job as a similar stacked chart.
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<script type="text/javascript" src="/omni/FusionCharts/FusionCharts.js"></script>
<div id="chocobar10">Issue Status by job</div>
<script type="text/javascript">
var bar10 = new FusionCharts("/omni/FusionCharts/StackedColumn3D.swf",
"chocobarId10", "250", "250", "0", "1");
bar10.setDataXML("<chart caption='Issues Statistics by job' showValues='1' xAxisName='Issue Status' yAxisName='Issues'>" +
"<categories>"+
"{SUBQUERY,Name=\"Getseverity\",Query=\"exec sp_jobwise_issues\",
Format=\" <category label='[jobdescription]'/>\",UseCache=\"False\"}"+
"</categories>"+
"<dataset seriesName='Issues Resolved/Closed'>"+
"{SUBQUERY,Name=\"Getseverity\",Query=\"exec omni_sp_jobwise_issues\",
Format=\" <set value='[closed]' link='newchart-xml-[jobid]-dd'/>\",UseCache=\"False\"}"+
"</dataset>"+
"<dataset seriesName='Issues Pending'>"+
"{SUBQUERY,Name=\"Getseverity\",Query=\"exec sp_jobwise_issues\",
Format=\" <set value='[pending]' link='newchart-xml-[jobid]-dd'/>\",UseCache=\"False\"}"+
"</dataset>"+
"{SUBQUERY,Name=\"dri\",Query=\"exec omni_sp_jobwise_issues\",
Format=\"\"<linkeddata id='[jobid]-dd'>\"+
\"<chart caption='Issues per team member' subcaption='Team Members' xAxisName='Team Member' yAxisName='Issues'>\"+
\"\{SUBQUERY\,Name=\"getCustomerscat\"\,Query=\"exec sp_employeewise_issues @job=[jobid]\"\,
Header=\"\"<categories>\"+\"\,
Format=\"\"<category label='[name]'/>\"+\"\,
Footer=\"\"</categories>\"+
\,UseCache=\"False\"\}\"+
\"\{SUBQUERY\,Name=\"getCustomersclosed\"\,Query=\"exec sp_employeewise_issues @job=[jobid]\"\,
Header=\"\"<dataset seriesName='Issues Resolved/Closed'>\"+\"\,
Format=\"\"<set value='[closed1]'/>\"+\"\,
Footer=\"</dataset>\"\,
UseCache=\"False\"\}\"+
\"\{SUBQUERY\,Name=\"getCustomerspending\"\,Query=\"exec sp_employeewise_issues @job=[jobid]\"\,
Header=\"\"<dataset seriesName='Issues pending'>\"+\"\,
Format=\"\"<set value='[pending1]'/>\"+\"\,
Footer=\"</dataset>\"\,
UseCache=\"False\"\}\"+
\"</chart>\"+\"</linkeddata>\"\"
,
UseCache=\"False\"}"+
"</chart>");
</script>
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
