Jesús Report post Posted February 11, 2012 Hi there, I have a problem with the plotting data, here is the thing, i do the query without problems and i can plot the graph too, but in the data i selected a date rank, so when i plot the graph the firts date is not in the graphic Example, i select the rank 2012-01-01 2012-01-02 2012-01-03 2012-01-04 2012-01-05 And the graphic starts with 2012-01-02, i attached the graphic and the source code, so i hope that you can help me. Greetings!! graphTBPS.php Share this post Link to post Share on other sites
Guest Sumedh Report post Posted February 13, 2012 Greetings. Could you please send us the generated XML file of your issue. It would be more helpful for us to look into it. Hope you have a great day. Share this post Link to post Share on other sites
Jesús Report post Posted February 13, 2012 Hi there, Here it is the xml code <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="../styles/style.css" rel="stylesheet" type="text/css" /> <script LANGUAGE="Javascript" SRC="../charts/FusionCharts.js"></script> <title>GRAFICANDO</title> </head> <center> <div id="PROSA" class="PROSA"> <p> </p> <!-- START Code Block for Chart PROSATBPS --> <div id="PROSATBPSDiv"> Chart </div> <script type="text/javascript" ><!-- // Instantiate the Chart var chart_PROSATBPS = new FusionCharts( { "swfUrl" : "../charts/Line.swf", "width" : "1000", "height" : "660", "renderAt" : "PROSATBPSDiv", "dataFormat" : "xml", "id" : "PROSATBPS", "wMode" : "opaque", "dataSource" : " <chart bgColor='FFFFFF,FFFFFF' bgAlpha='2' bgRatio='5' bgAngle='45' setAdaptiveYMin='1' showBorder='0' outCnvBaseFont='Verdana' outCnvBaseFontSize='11' outCnvBaseFontColor='000000' caption='Producto: ATM' subcaption='Ambiente: NACIONAL' xAxisName='Fecha' yAxisName='Millones de Transacciones' showValues='1' rotateValues='1' labelStep='2' divLineColor='000000' canvasBorderThickness='1' canvasPadding='6' canvasbgColor='D02727' canvasbgAlpha='10' labelDisplay='Rotate' setAdaptiveYMin='1' formatNumberScale='0' adjustDiv='0' showShadow='0' baseFontSize='11' lineColor='d02727' lineThickness='2' lineAlpha='50' showExportDataMenuItem='1' exportDataMenuItemLabel='Copiar los datos de este grafico'> <set label='Mon 02-01-2012' value='1077099' /> <set label='Tue 03-01-2012' value='966485' /> <set label='Wed 04-01-2012' value='963225' /> <set label='Thu 05-01-2012' value='1197053' /> </chart>" } ).render(); // --></script> <!-- END Script Block for Chart PROSATBPS --> </div> </center> </body> </html> i hope that you can help me greetings !! Greetings. Could you please send us the generated XML file of your issue. It would be more helpful for us to look into it. Hope you have a great day. Share this post Link to post Share on other sites
Swarnam Report post Posted February 14, 2012 Hi, In the code attached, there was no corresponding set element provided for '2012-01-01'. Hence, it was not displayed. If the following line of code was included , it will display the line from 2012-01-01: <set label='Mon 01-01-2012' value='977099' /> Hope this helps. Share this post Link to post Share on other sites
Jesús Report post Posted February 16, 2012 Thanks Swarman, you're right, ahd thats the real problem, because in the query i got the rank complete, but in the function that plot the graph it seems like the first record is missing, so i hope that you can help me to understand why this record is missing. Hi, In the code attached, there was no corresponding set element provided for '2012-01-01'. Hence, it was not displayed. If the following line of code was included , it will display the line from 2012-01-01: <set label='Mon 01-01-2012' value='977099' /> Hope this helps. Share this post Link to post Share on other sites
Jesús Report post Posted February 16, 2012 Thanks Swarman, you're right, ahd thats the real problem, because in the query i got the rank complete, but in the function that plot the graph it seems like the first record is missing, so i hope that you can help me to understand why this record is missing. Hi, In the code attached, there was no corresponding set element provided for '2012-01-01'. Hence, it was not displayed. If the following line of code was included , it will display the line from 2012-01-01: <set label='Mon 01-01-2012' value='977099' /> Hope this helps. Share this post Link to post Share on other sites
Guest Sumedh Report post Posted February 17, 2012 Greetings, If you are generating XML, it has a specific standard. Please note, while generating the XML, there should be a corresponding set element. If the XML is not generated in proper format, data will not be displayed properly on the chart, Hence chart will look faulty. Hope this helps. Share this post Link to post Share on other sites
Jesús Report post Posted February 17, 2012 Thanks Sumedh, do you have something like an example ?? or if you can check my source code please, in order to find my mistake, thanks a lot !! Greetings, If you are generating XML, it has a specific standard. Please note, while generating the XML, there should be a corresponding set element. If the XML is not generated in proper format, data will not be displayed properly on the chart, Hence chart will look faulty. Hope this helps. Share this post Link to post Share on other sites
Guest Sumedh Report post Posted February 20, 2012 Hi, Add following line of code under the chart element in the XML file. <set label='Mon 01-01-2012' value='977099' /> This would display the required date on the chart. Hope this helps. Share this post Link to post Share on other sites
