Skip to main content
Gene_Godsey
Gene_Godsey
Inspiring
May 23, 2008
Question

CFChart

  • May 23, 2008
  • 2 replies
  • 588 views
How can I get looped Data output into a CFChart display?
    This topic has been closed for replies.

    2 replies

    Gene_Godsey
    Gene_GodseyAuthor
    Inspiring
    May 23, 2008
    Nested Loops work.

    I.E.:
    -------------------------------
    <!--- Data Calls are here. --->
    <cfinvoke component="components.Archive" method="pullAllOrg" returnvariable="paoVar"/>
    <cfparam name="postback" type="numeric" default="0">
    <!--- End of the Data Calls. --->

    <body topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

    <cfform action="#cgi.SCRIPT_NAME#?id=40&postback=1" method="post" format="html">

    <Table align="center">

    <tr>
    <td>
    <Table align="center">
    <tr>
    <td colspan="2">
    <font color="Blue"><strong><em>Lean Six Sigma Selection One.</strong></em></font>
    </td>
    </tr>
    <tr>
    <td><font size="-1"><strong>Year:</strong></font></td>
    <td style="position:relative;z-index:2;">
    <!--- <cfinput type="text" name="year" autosuggest="#ValueList(yearVar.Year)#" size="5"> --->
    <cfselect name="year" style="width:75;" queryposition="below">
    <option value="2008" selected="2008">2008</option>
    <option value="2009">2009</option>
    <option value="2010">2010</option>
    <option value="2011">2011</option>
    </cfselect>
    </td>
    </tr>
    <tr>
    <td><font size="-1"><strong>Qtr:</strong></font></td>
    <td style="position:relative;z-index:1;">
    <!--- <cfinput type="text" name="qtr" autosuggest="#ValueList(pVar.quarter)#" size="5"> --->
    <cfselect name="qtr" style="width:30;" queryposition="below">
    <option value="1" selected="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    </cfselect>
    </td>
    </tr>
    <tr>
    <td><font size="-1"><strong>Org:</strong></font></td>
    <td><cfselect name="org" query="paoVar" display="OrgName" value="autoid" enabled="true" visible="true"/></td>
    </tr>
    </Table>
    </td>
    <td>
    <Table align="center">
    <tr>
    <td colspan="2">
    <font color="Red"><strong><em>Lean Six Sigma Selection Two.</strong></em></font>
    </td>
    </tr>
    <tr>
    <td><font size="-1"><strong>Year:</strong></font></td>
    <td style="position:relative;z-index:2;">
    <!--- <cfinput type="text" name="year" autosuggest="#ValueList(yearVar.Year)#" size="5"> --->
    <cfselect name="year2" style="width:75;" queryposition="below">
    <option value="2008" selected="2008">2008</option>
    <option value="2009">2009</option>
    <option value="2010">2010</option>
    <option value="2011">2011</option>
    </cfselect>
    </td>
    </tr>
    <tr>
    <td><font size="-1"><strong>Qtr:</strong></font></td>
    <td style="position:relative;z-index:1;">
    <!--- <cfinput type="text" name="qtr" autosuggest="#ValueList(pVar.quarter)#" size="5"> --->
    <cfselect name="qtr2" style="width:30;" queryposition="below">
    <option value="1" selected="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    </cfselect>
    </td>
    </tr>
    <tr>
    <td><font size="-1"><strong>Org:</strong></font></td>
    <td><cfselect name="org2" query="paoVar" display="OrgName" value="autoid" enabled="true" visible="true"/></td>
    </tr>
    </Table>
    </td>
    </tr>
    <tr>
    <tr>
    <td colspan="2" align="center"><cfinput type="submit" name="submitit" value="Request Report!"></td>
    </tr>
    </tr>

    </Table>
    </cfform>

    <cfif postback eq "1">

    <cfinvoke component="components.Archive" method="readArchivedReport" returnvariable="Var">
    <cfinvokeargument name="year" value="#form.year#">
    <cfinvokeargument name="qtr" value="#form.qtr#">
    <cfinvokeargument name="org" value="#form.org#">
    </cfinvoke>
    <cfinvoke component="components.Archive" method="readArchivedReport" returnvariable="Var2">
    <cfinvokeargument name="year" value="#form.year2#">
    <cfinvokeargument name="qtr" value="#form.qtr2#">
    <cfinvokeargument name="org" value="#form.org2#">
    </cfinvoke>




    <div align="center">
    <table align="center">
    <cfchart format="flash" chartwidth="900" chartheight="250" show3d="true" backgroundcolor="##ffffff"
    databackgroundcolor="##ffffff" seriesplacement="default" title="Lean Six Sigma: Year #form.year# -- Quarter #form.qtr#"
    xaxisTitle="Metric Name" yaxistitle="Percentages">


    <cfchartseries type="bar" paintstyle="raise" seriescolor="red">
    <cfloop query="Var">
    <cfscript>
    set1 = #Var.measure1#;
    set2 = #Var.measure2#;
    category = #Var.CatName#;
    if (set1 eq ""){
    set1 = 0.111;
    }else{
    set1 = set1;
    }
    if (set2 eq ""){
    set2 = 0.222;
    }else{
    set2 = set2;
    }
    Rating = ((set2)/(set1)*100);
    telephoneSwitchLines = (((set1)-(set2))/(set1)*100);
    </cfscript>


    <cfloop index="i" list="#CatName#">
    <cfchartdata item="#i#" value="#rating#">
    </cfloop>

    </cfloop>
    </cfchartseries>
    </cfchart>
    </div>
    <div align="center">
    <cfchart format="flash" chartwidth="900" chartheight="250" show3d="true" backgroundcolor="##ffffff"
    databackgroundcolor="##ffffff" seriesplacement="default" title="Lean Six Sigma: Year #form.year2# -- Quarter #form.qtr2#"
    xaxisTitle="Metric Name" yaxistitle="Percentages">


    <cfchartseries type="bar" paintstyle="raise" seriescolor="green">
    <cfloop query="Var2">
    <cfscript>
    set1 = #Var2.measure1#;
    set2 = #Var2.measure2#;
    if (set1 eq ""){
    set1 = 0.111;
    }else{
    set1 = set1;
    }
    if (set2 eq ""){
    set2 = 0.222;
    }else{
    set2 = set2;
    }
    Rating2 = ((set2)/(set1)*100);
    telephoneSwitchLines = (((set1)-(set2))/(set1)*100);
    </cfscript>
    <cfloop index="i" list="#CatName#">
    <cfchartdata item="#i#" value="#rating2#">
    </cfloop>
    </cfloop>
    </cfchartseries>
    </cfchart>
    </div>



    </cfif>
    D
    Dan_Bracuk
    Inspiring
    May 23, 2008
    What's the part you are having trouble with?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices