stineco Report post Posted April 1, 2015 Hi, I am using fusionchart XT to generate charts from my MS SQL SERVER. I have no problem to get the data from my server into my charts (Bar,Pie,...) but when i wanna put data in Multi-series charts i dont now how. Can someone help my with a example. Tnx. Share this post Link to post Share on other sites
Vishalika Report post Posted April 2, 2015 Hi, Welcome to FusionCharts Forum. To get multi-series data you need to format the XML/JSON data retrieved as per the FusionCharts format. Could you confirm which server side language you are using so that we can help you out with a sample? Also, check out this link if it helps: http://docs.fusioncharts.com/tutorial-using-with-server-side-languages-php-different-ways-of-loading-data.html Awaiting response. Share this post Link to post Share on other sites
stineco Report post Posted April 2, 2015 Hi, I am using PHP. Greetz stino Share this post Link to post Share on other sites
Vishalika Report post Posted April 8, 2015 Hi, We are working on it. Will keep you posted. Share this post Link to post Share on other sites
Vishalika Report post Posted April 22, 2015 Hi, We have created a sample using PHP-MySQL with XML data format. Sharing the same with you as per your requirement. Refer this link for sample: https://www.dropbox.com/s/s7hq6bjqxk5x6ar/php_multiseries_%20XML.rar?dl=0 Hope this helps. Share this post Link to post Share on other sites
stineco Report post Posted April 23, 2015 Hi, Already a big thanks, but there is a problem, i have deleted the data from factory 2 date 1-02-2003 but when i go to the chart, factory 1,2,3 on show everything on the first datefactory 1,2,3 on the show everything second date On the third date is shows only factory 1 and 3But i have deleted one line in the output table from factory 2 (second date) Can you check this? Thanx Share this post Link to post Share on other sites
stineco Report post Posted April 23, 2015 The problem is that if one value is not there, the output goes wrong, the xml is created correct. The solution is that to create a <set value=''>. any help? Share this post Link to post Share on other sites
Vishalika Report post Posted April 24, 2015 Hi, Can you please share the screenshot? Since we are unable to replicate. Awaiting response. Share this post Link to post Share on other sites
stineco Report post Posted April 27, 2015 (edited) Hi, This is the screenshot The generated code of the html file <html> <head> <title>FusionCharts XT - Column 2D Chart - Data from a database</title> <link rel="stylesheet" type="text/css" href="css/style.css" /> <!-- You need to include the following JS file to render the chart. When you make your own charts, make sure that the path to this JS file is correct. Else, you will get JavaScript errors. --> <script src="fusioncharts/fusioncharts.js"></script> </head> <body> <script type="text/javascript"> FusionCharts.ready(function () { new FusionCharts({"type":"mscolumn2d","id":"myFirstChart","width":600,"height":300,"renderAt":"chart-1","dataFormat":"xml","dataSource":'<chart caption= "Top 10 Most Populous Countries" paletteColors= "#0075c2,#00ff00,#ff00a5" bgColor= "#ffffff" borderAlpha= "20" canvasBorderAlpha= "0" usePlotGradientColor= "0" plotBorderAlpha= "10" showXAxisLine= "1" xAxisLineColor= "#999999" showValues= "0" divlineColor= "#999999" divLineIsDashed= "1" showAlternateHGridColor= "0" ><categories><category label="1-01-2003" /><category label="1-02-2003" /><category label="1-03-2003" /></categories><dataset seriesName=" Factory1 "><set value="21" /><set value="23" /><set value="22" /></dataset><dataset seriesName=" Factory2 "><set value="121" /><set value="122" /></dataset><dataset seriesName=" Factory3 "><set value="54" /><set value="56" /><set value="89" /></dataset></chart>'}); }); </script> <script type='text/javascript'> FusionCharts.ready(function () { FusionCharts("myFirstChart").render(); }); </script> <div id="chart-1">Fusion Charts will render here</div> </body> </html> Edited April 27, 2015 by stineco Share this post Link to post Share on other sites
stineco Report post Posted June 10, 2015 (edited) Someone any progress or solution if there are missing values? Edited June 10, 2015 by stineco Share this post Link to post Share on other sites
Vishalika Report post Posted June 11, 2015 Hi, The issue is replicated. But as per your use case another condition has to be included in the code for this scenario. Another 'if' clause for the null data will help to solve out the issue. Currently no sample implementation is present. We will try to share the same as soon as possible. Share this post Link to post Share on other sites
kmm2908 Report post Posted July 8, 2015 Hi For me when I include the fusioncharts.php file I get a blank page. No error message. Checked path is correct by loading get file in the browser from the include path I use; fine. If I comment out include the rest of the page loads fine. I've downloaded the wrapper file twice and uploaded twice. Any suggestions please? Share this post Link to post Share on other sites
Vishalika Report post Posted July 8, 2015 Hi, Welcome to FusionCharts Forum. Can you provide some more details like are you trying to render the chart using the database or static string of data? Also which version of FusionCharts you are using? You can refer the latest sample of FusionCharts using PHP wrapper: https://www.dropbox.com/s/4g2gur3f3vdeb67/php_samplewith_%20XML.rar?dl=0 Awaiting response. Share this post Link to post Share on other sites
vantel15 Report post Posted December 25, 2015 How to use JSON multiple series using PHP and MySQL, because i'm using JSON,not XML. Please help me. Share this post Link to post Share on other sites
Vishalika Report post Posted December 29, 2015 Hi, Sharing a sample of PHP and MySQL with JSON data: https://www.dropbox.com/s/ruk3hth9xs6ejou/mschart_php-sql.rar?dl=0 Please check and share your feedback. Share this post Link to post Share on other sites
butterfly123 Report post Posted June 2, 2016 Hi, Please can someone inform me if there is way of generating charts from my SQL server, but not from different tables, I have one table which contain lot of column and i want to compare two or more columns choosed by the user whilst checking a checkbox. I wanna put data in Multi-series charts but i dont now how it works. I am in a big trouble ! Share this post Link to post Share on other sites
Gagan Sikri Report post Posted June 8, 2016 HiYou can refer to this link to download a sample for multi-series chart with PHP and MySQL using data from single table: https://www.dropbox.com/s/82femvv3yqnddkc/multi-series-mysql.zip?dl=0 It includes SQL dump as well. Hope it helps. Share this post Link to post Share on other sites
Vijaya Bhaskar V Report post Posted July 4, 2017 Can you please provide the sample for mysql using jsp Share this post Link to post Share on other sites
Ayan Bhadury Report post Posted July 4, 2017 Hi, Kindly refer this documentation url, it will guide how to render FusionCharts using jsp wrapper where the datas are fetched from database.http://www.fusioncharts.com/dev/using-with-server-side-languages/java/creating-charts-with-data-from-a-database.html Share this post Link to post Share on other sites
Vijaya Bhaskar V Report post Posted July 5, 2017 6 hours ago, Ayan Bhadury said: Hi, Kindly refer this documentation url, it will guide how to render FusionCharts using jsp wrapper where the datas are fetched from database.http://www.fusioncharts.com/dev/using-with-server-side-languages/java/creating-charts-with-data-from-a-database.html Hi , I need the sample code for multi series bar chart only . I have tried the bar chart . That gets worked out . But in multi series or stacked charts only the forming of data is difficult . Share this post Link to post Share on other sites
Ayan Bhadury Report post Posted July 5, 2017 Hi, https://www.dropbox.com/s/igei6jr3mto0amu/stacked-bar-db.zip?dl=0 Please download the sample of stacked-bar chart from the given dropbox link. Share this post Link to post Share on other sites
