All Activity

This stream auto-updates     

  1. Today
  2. Error data output (json) stackedcolumn2d

    Please update the demo with your chart data ; https://jsfiddle.net/qjd56g8h/
  3. { "value": null }, this shouldn't be there
  4. What I mean is that the dataset should start with; "dataset": [{ "seriesname": "NULL", "data": [{ "value": null, "link": "sa_chart_station_detail.php?pid_station=1" }, instead it starts with; "dataset": [{ "seriesname": "NULL", "data": [{ "value": null }, { "value": null, "link": "sa_chart_station_detail.php?pid_station=1" },
  5. Sorry, can you try to render a scrollstackedcolumn2d chart with the data I shared with you? You will see that the data that the chart presents is not correct
  6. Excuse me ... how can I do a check in the firefox or chrome console?
  7. Error data output (json) stackedcolumn2d

    0 is considered as a number, it will obviously take a plot space based on your y-axis scale if you do not want to show any plot use null instead of 0, here is a demo : http://jsfiddle.net/bzdso20y/
  8. Firstly, as you can see the first value of the dataset is a zero that shouldn't come up, this in my opinion is wrong. {"value":"0"},
  9. {"chart":{"caption":"","bgColor":"#ffffff","borderAlpha":"","showBorder":"0","showCanvasBg":"0","showCanvasBase":"1","canvasBaseDepth":"14","canvasBgDepth":"5","canvasBaseColor":"#ffffff","canvasBgColor":"#ffffff","theme":"fusion","palettecolors":"#e0e0e0,#13ac0b,#f72b10,#f59054"},"categories":[{"category":[{"label":"AG"},{"label":"AL"},{"label":"AN"},{"label":"AO"},{"label":"APR"},{"label":"AQ1"},{"label":"AR"},{"label":"AT"},{"label":"BA"},{"label":"BDG"},{"label":"BG"},{"label":"BIE"},{"label":"BNS"},{"label":"BO1"},{"label":"BO14"},{"label":"BS"},{"label":"BUS"},{"label":"BZ"}]}],"dataset":[{"seriesname":"NULL","data":[{"value":"0"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=1"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=2"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=3"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=5"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=6"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=7"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=8"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=9"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=10"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=12"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=13"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=14"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=15"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=16"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=17"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=18"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=19"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=20"}]},{"seriesname":"SI","data":[{"value":"61"},{"value":"61","link":"sa_chart_station_detail.php?pid_station=1"},{"value":"37","link":"sa_chart_station_detail.php?pid_station=2"},{"value":"48","link":"sa_chart_station_detail.php?pid_station=3"},{"value":"58","link":"sa_chart_station_detail.php?pid_station=5"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=6"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=7"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=8"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=9"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=10"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=12"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=13"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=14"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=15"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=16"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=17"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=18"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=19"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=20"}]},{"seriesname":"NO","data":[{"value":"0"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=1"},{"value":"13","link":"sa_chart_station_detail.php?pid_station=2"},{"value":"10","link":"sa_chart_station_detail.php?pid_station=3"},{"value":"2","link":"sa_chart_station_detail.php?pid_station=5"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=6"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=7"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=8"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=9"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=10"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=12"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=13"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=14"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=15"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=16"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=17"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=18"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=19"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=20"}]},{"seriesname":"N\/A","data":[{"value":"0"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=1"},{"value":"11","link":"sa_chart_station_detail.php?pid_station=2"},{"value":"3","link":"sa_chart_station_detail.php?pid_station=3"},{"value":"1","link":"sa_chart_station_detail.php?pid_station=5"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=6"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=7"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=8"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=9"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=10"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=12"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=13"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=14"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=15"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=16"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=17"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=18"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=19"},{"value":"0","link":"sa_chart_station_detail.php?pid_station=20"}]}]} json outuput and this is query output pid_station num_risposta tipo_risposta station totali 1 0 NULL AG 0 2 0 NULL AL 0 3 0 NULL AN 0 5 0 NULL AO 0 6 0 NULL APR 61 7 0 NULL AQ1 61 8 0 NULL AR 61 9 0 NULL AT 61 10 0 NULL BA 61 12 0 NULL BDG 61 13 0 NULL BG 61 14 0 NULL BIE 61 15 0 NULL BNS 61 16 0 NULL BO1 61 17 0 NULL BO14 61 18 0 NULL BS 61 19 0 NULL BUS 61 20 0 NULL BZ 61 1 1 SI AG 61 2 1 SI AL 37 3 1 SI AN 48 5 1 SI AO 58 6 1 SI APR 0 7 1 SI AQ1 0 8 1 SI AR 0 9 1 SI AT 0 10 1 SI BA 0 12 1 SI BDG 0 13 1 SI BG 0 14 1 SI BIE 0 15 1 SI BNS 0 16 1 SI BO1 0 17 1 SI BO14 0 18 1 SI BS 0 19 1 SI BUS 0 20 1 SI BZ 0 1 2 NO AG 0 2 2 NO AL 13 3 2 NO AN 10 5 2 NO AO 2 6 2 NO APR 0 7 2 NO AQ1 0 8 2 NO AR 0 9 2 NO AT 0 10 2 NO BA 0 12 2 NO BDG 0 13 2 NO BG 0 14 2 NO BIE 0 15 2 NO BNS 0 16 2 NO BO1 0 17 2 NO BO14 0 18 2 NO BS 0 19 2 NO BUS 0 20 2 NO BZ 0 1 3 N/A AG 0 2 3 N/A AL 11 3 3 N/A AN 3 5 3 N/A AO 1 6 3 N/A APR 0 7 3 N/A AQ1 0 8 3 N/A AR 0 9 3 N/A AT 0 10 3 N/A BA 0 12 3 N/A BDG 0 13 3 N/A BG 0 14 3 N/A BIE 0 15 3 N/A BNS 0 16 3 N/A BO1 0 17 3 N/A BO14 0 18 3 N/A BS 0 19 3 N/A BUS 0 20 3 N/A BZ 0
  10. Error data output (json) stackedcolumn2d

    What is the error you are getting? could you please share the JSON data that is retrieved after the chart is rendered? You can check the view page source and share the JSON data or you in the browser console type FusionCharts.items[''chart-object"].getJSONData()
  11. Many thanks Ayan Bhadury, I solved part of the problem with a new query. I understand that the staked chart needs a name-value pair, now the query output is correct. answer station answer_count N/A AG 0 N/A AL 11 N/A AN 3 N/A AO 1 N/A APR 0 N/A AQ1 0 N/A AR 0 N/A AT 0 N/A BA 0 NO AG 0 NO AL 13 NO AN 10 NO AO 2 NO APR 0 NO AQ1 0 NO AR 0 NO AT 0 NO BA 0 NULL AG 0 NULL AL 0 NULL AN 0 NULL AO 0 NULL APR 61 NULL AQ1 61 NULL AR 61 NULL AT 61 NULL BA 61 YES AG 61 YES AL 37 YES AN 48 YES AO 58 YES APR 0 YES AQ1 0 YES AR 0 YES AT 0 YES BA 0 But as you can see there is still an error in the json output. The query data is not correctly displayed in the chart. I used this php script to generate the json <?php include("DBConn.php"); include("fusioncharts/fusioncharts.php"); $strQueryCategories = "SELECT DISTINCT station FROM v_answer"; $resultCategories = $conn->query($strQueryCategories)or exit("Error code ({$conn->errno}): {$conn->error}"); $strQueryData = "SELECT answer, station, answer_count FROM v_answer"; $resultData = $conn->query($strQueryData)or exit("Error code ({$conn->errno}): {$conn->error}"); if ($resultData) { $arrData = array( "chart" => array( "caption" => "", "bgColor" => "#ffffff", "borderAlpha" => "", "showBorder"=> "0", "showCanvasBg" => "0", "showCanvasBase" => "1", "canvasBaseDepth" => "14", "canvasBgDepth" => "5", "canvasBaseColor" => "#ffffff", "canvasBgColor" => "#ffffff", "theme"=> "fusion", "palettecolors" => "#e0e0e0,#13ac0b,#f72b10,#f59054", ) ); $arrData["categories"] = array(array("category" => array())); if ($resultCategories) { $controlBreakValue = ""; while ($row = mysqli_fetch_array($resultCategories)) { if ($controlBreakValue != $row["station"]) { $controlBreakValue = $row["station"]; array_push( $arrData["categories"][0]["category"], array("label" => $controlBreakValue)); $controlBreakValue == ""; } } } $arrData["dataset"] = array(); $i = 0; if ($resultData) { $controlBreakValue = ""; while ($row = mysqli_fetch_array($resultData)) { if ($controlBreakValue != $row["answer"]) { $controlBreakValue = $row["answer"]; array_push($arrData["dataset"], array("seriesname" => $controlBreakValue, "data" => array(array("value" => $row["answer_count"])))); $controlBreakValue == ""; $i++; } array_push($arrData["dataset"][$i -1]["data"], array("value" => $row["answer_count"])); } } } $jsonEncodedData = json_encode($arrData); $conn->close(); echo $jsonEncodedData; ?>
  12. Idea for adding context menu in node drag chart for specific node

    1 - You can add an icon in the form of an image and drag it. 2 - If you need two-way communication check out Sankey diagram : https://www.fusioncharts.com/charts/sankey-diagram/simple-sankey-diagram?framework=javascript
  13. Error data output (json) stackedcolumn2d

    Here is a demo based on your data : http://jsfiddle.net/x937haw5/1/
  14. Yesterday
  15. Idea for adding context menu in node drag chart for specific node

    Thank for your answer! #1.Unfortunately the client didn't agreed with that solution. It supposed to be icon next to node. I was thinking about use event where I before render the icon I will move it. Any ideas? #2. Another thing that comes out is connector. Is any possibility to provide 2 connectors between to the same nodes? Client wants to have something like in the pic below:
  16. Last week
  17. Hi everyone, i can't get a stackedcolumn2d chart to work, the query is correct, instead the json output returns wrong data, how is this possible? This is output MySql query answer station answer_count NULL APR 61 NULL AQ1 61 NULL AR 61 NULL AT 61 NULL BA 61 NULL BDG 61 NULL BG 61 NULL BIE 61 NULL BNS 61 NULL BO1 61 NULL BO14 61 NULL BS 61 NULL BUS 61 NULL BZ 61 YES AG 61 YES AL 37 YES AN 48 YES AO 58 NO AL 13 NO AN 10 NO AO 2 N/A AL 11 N/A AN 3 N/A AO 1 And this is output json, is not correct, have you any ideas? categories":[{" category":[{"label":"AG"},{"label":"AL"},{"label":"AN"},{"label":"AO"},{"label":"APR"},{"label":"AQ1"},{"label":"AR"},{"label":"AT"},{"label":"BA"},{"label":"BDG"},{"label":"BG"},{"label":"BIE"},{"label":"BNS"},{"label":"BO1"},{"label":"BO14"},{"label":"BS"},{"label":"BUS"},{"label":"BZ"}]}]," dataset":[{ "seriesname":"NULL","data":[{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"},{"value":"61"}]},{ "seriesname":"YES","data":[{"value":"61"},{"value":"61"},{"value":"37"},{"value":"48"},{"value":"58"}]},{ "seriesname":"NO","data":[{"value":"13"},{"value":"13"},{"value":"10"},{"value":"2"}]},{ "seriesname":"N\/A","data":[{"value":"11"},{"value":"11"},{"value":"3"},{"value":"1"}]}]}
  18. Hi, For the first chart refer to this link: https://www.fusioncharts.com/fusiontime/examples/annotating-single-data-point?framework=javascript For spider chart refer to this page : https://www.fusioncharts.com/charts/radar-spider-charts
  19. How to use the license key with php

    For license key related queries, please drop a mail to [email protected]
  20. How to use the license key with php

    I was able to figure this out. A couple of hints for others who might have this issue... Don't just use the snippet they send you. You need to quote (or at least I did) the license key or it doesn't work. After I figured that out, it was pretty easy just putting the snippet in on the page where I needed to render the chart.
  21. Anyone else using the PHP wrapper and the license key? How do you implement it? The documentation seems to be rather depressingly lacking and I wish my company had went with another solution.
  22. Idea for adding context menu in node drag chart for specific node

    Please refer to the demo, at the top right you would see a toolbar you can add a node using that.
  23. Idea for adding context menu in node drag chart for specific node

    I was referring to a custom window not the one that brings by default fusion chart for nodes and connectors
  24. Idea for adding context menu in node drag chart for specific node

    http://jsfiddle.net/0fqjeyLa/
  25. Idea for adding context menu in node drag chart for specific node

    I'm still struggling with a contextual menu to be able to add nodes and connectors, won't you have an example of the possibility of doing that? or how can I only get the events? Thanks a lot
  26. Idea for adding context menu in node drag chart for specific node

    Please let me know.
  27. Idea for adding context menu in node drag chart for specific node

    Thank you very much, I appreciate your support. May I bother with another question?
  1. Load more activity