All Activity

This stream auto-updates     

  1. Today
  2. Wiki Contributors joined the community
  3. RonnieTredy joined the community

  4. Error data output (json) stackedcolumn2d

    Ayan Bhadury replied to RTime's topic in FusionCharts and PHP

    Please update the demo with your chart data ; https://jsfiddle.net/qjd56g8h/

  5. Error data output (json) stackedcolumn2d

    Ayan Bhadury replied to RTime's topic in FusionCharts and PHP

  6. { "value": null }, this shouldn't be there
  7. 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" },
  8. 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
  9. Excuse me ... how can I do a check in the firefox or chrome console?

  10. Error data output (json) stackedcolumn2d

    Ayan Bhadury replied to RTime's topic in FusionCharts and PHP

    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/
  11. 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"},
  12. {"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
  13. Sienna Parry changed their profile photo
  14. Sienna Parry joined the community
  15. Jacket Arena changed their profile photo
  16. Jacket Arena joined the community
  17. SofiaBarnett joined the community
  18. BrandonGN joined the community
  19. GeorxxgeLible joined the community

  20. Error data output (json) stackedcolumn2d

    Ayan Bhadury replied to RTime's topic in FusionCharts and PHP

    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()
  21. MillayMoede joined the community
  22. 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; ?>

  23. Idea for adding context menu in node drag chart for specific node

    Ayan Bhadury replied to Szymon Wojciechowski's topic in Using PowerCharts XT

    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
  24. Ayan Bhadury started following Error data output (json) stackedcolumn2d

  25. Error data output (json) stackedcolumn2d

    Ayan Bhadury replied to RTime's topic in FusionCharts and PHP

    Here is a demo based on your data : http://jsfiddle.net/x937haw5/1/
  26. anusaxena changed their profile photo
  27. Yesterday
  28. Anifyclume started following Detailed world map
  29. paulolopez changed their profile photo
  30. RTime started following Error data output (json) stackedcolumn2d
  31. Steel Pipes/Tubes Industri changed their profile photo
  32. The Metals Factory changed their profile photo
  33. Asiamet Steel Industries changed their profile photo

  34. Idea for adding context menu in node drag chart for specific node

    Szymon Wojciechowski replied to Szymon Wojciechowski's topic in Using PowerCharts XT

    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:
  35. Last week
  36. Anifyclume started following Invalid Data Message
  37. Olesya started following Tooltip Issue with Scrollstackedcolumn2D
  38. Sands Inn & Suites changed their profile photo
  39. 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"}]}]}
  40. bongdaxoivo changed their profile photo
  41. manvikakkar99 changed their profile photo
  42. Ayan Bhadury started following How to use the license key with php and looking to adapt a spider or star chart for online dashboard
  43. 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

  44. How to use the license key with php

    Ayan Bhadury replied to jwall1848's topic in FusionCharts and PHP

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

  46. How to use the license key with php

    jwall1848 replied to jwall1848's topic in FusionCharts and 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.
  47. 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.
  48. MyrnaHardison started following looking to adapt a spider or star chart for online dashboard

  49. Idea for adding context menu in node drag chart for specific node

    Ayan Bhadury replied to Gonzalo Alberto Castillo's topic in Using PowerCharts XT

    Please refer to the demo, at the top right you would see a toolbar you can add a node using that.

  50. Idea for adding context menu in node drag chart for specific node

    Gonzalo Alberto Castillo replied to Gonzalo Alberto Castillo's topic in Using PowerCharts XT

    I was referring to a custom window not the one that brings by default fusion chart for nodes and connectors

  51. Idea for adding context menu in node drag chart for specific node

    Ayan Bhadury replied to Gonzalo Alberto Castillo's topic in Using PowerCharts XT

    http://jsfiddle.net/0fqjeyLa/

  52. Idea for adding context menu in node drag chart for specific node

    Gonzalo Alberto Castillo replied to Gonzalo Alberto Castillo's topic in Using PowerCharts XT

    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

  53. Idea for adding context menu in node drag chart for specific node

    Ayan Bhadury replied to Gonzalo Alberto Castillo's topic in Using PowerCharts XT

    Please let me know.

  54. Idea for adding context menu in node drag chart for specific node

    Gonzalo Alberto Castillo replied to Gonzalo Alberto Castillo's topic in Using PowerCharts XT

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