Jamie 1

  • Content count

  • Joined

  • Last visited

About Jamie 1

  • Rank
    Advanced Member
  1. Images Above Column

    Thank you Akash. That was exactly what I was looking for. Many thanks.
  2. Images Above Column

    Hello. I would like to add an image above each column in my chart. So the image will represent the data in the column. I think I saw something about this once but cannot find it now. Any help please? Jamie
  3. Angle Gauge Limits

    Hello. I am making a gauge to show if we are ahead or behind our schedule. Hence the gauge needs to swing from -60 mins to +60 mins, with '0' at the centre. Problem. I have the Lower Value set at -60 and it needs to stay there so the gauge looks level. BUT upon update the Lower Limit always increases the lower limit. This happens regardless of the updated value. So if the updated value is +14, it still changes the Lower Limit. See picture. How can I stop it changing its self please? Jamie $Schedule = array( "chart" => array( "caption" => $schedule_main[0]['n1'], "showValue" => "1", "valueBelowPivot" => "1", "majorTMNumber" => "4", "minorTMNumber" => "4", "gaugeFillMix" => "{dark-30},{light-60},{dark-10}", "gaugeOuterRadius" => "100%", "gaugeInnerRadius" => "60%", "minValue" => "-60", "theme" => "fint" ) ); $colorRange = array( "color" => array( array( "minValue" => "-60", "maxValue" => $schedule_main[0]['t2'], "code" => $schedule_main[0]['colourL'] ), array( "minValue" => $schedule_main[0]['t2'], "maxValue" => $schedule_main[0]['t1'], "code" => $schedule_main[0]['colourM'] ), array( "minValue" => $schedule_main[0]['t1'], "maxValue" => $schedule_main[0]['tmax'], "code" => $schedule_main[0]['colourH'] ) ) );
  4. Drill-Down Chart from DB on Same Page

    Prerana. One problem I have with the sample code. It seems I have to manually write each year in the code. $arrDataMonth[2011]["linkeddata"] = array(); $arrDataMonth[2012]["linkeddata"] = array(); How do I get this to list the years automatically please? // data for linked chart will start from here, SQL query from quarterly_sales table $year = 2011; $strQuarterly = "SELECT Quarter, (Sales * 20) as Sales , Year FROM quarterly_sales WHERE 1"; $resultQuarterly = $dbhandle->query($strQuarterly) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); // if the query returns a valid response, preparing the associative JSON array for child chart if ($resultQuarterly) { $arrData["linkeddata"] = array(); // `linkeddata` is responsible for feeding data and chart options to child charts. $arrDataMonth[2011]["linkeddata"] = array(); $arrDataMonth[2012]["linkeddata"] = array(); $arrDataMonth[2013]["linkeddata"] = array(); $arrDataMonth[2014]["linkeddata"] = array(); $arrDataMonth[2015]["linkeddata"] = array(); $arrDataMonth[2016]["linkeddata"] = array(); $i = 0; if ($resultQuarterly) { while ($row = mysqli_fetch_array($resultQuarterly)) { // collect the year for which quarterly drilldown will be created $year = $row['Year']; // create the monthly drilldown data $arrMonthHeader[$year][$row["Quarter"]] = array(); $arrMonthData[$year][$row["Quarter"]] = array();
  5. Drill-Down Chart from DB on Same Page

    Thank you Prerana. That has massively helped me. I still need to figure out some parts but hopefully I should be ok now. Thanks again. Jamie. ps. Any idea when Fusioncharts Play will be available?
  6. Hello. This has me stumped for several days. I need a drill down chart to open to another chart on the same page. I can't find anything to help with this. I am drawing from MySql. I have it working but only drilling in the same chart. It needs to go to another div. The child data is from a php file as shown below. What changes do I need to do to drill to another div please? Thanks. Jamie. <body> <?php // Form the SQL query that returns the top 10 most populous countries $strQuery = "SELECT a.areaname as Name, a.areaid as Population, a.areaid as Code FROM area a ORDER BY Population DESC LIMIT 10"; // Execute the query, or else return the error message. $result = $dbhandle->query($strQuery) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); // If the query returns a valid response, prepare the JSON string if ($result) { // The `$arrData` array holds the chart attributes and data $arrData = array( "chart" => array( "caption" => "Top 10 Most Populous Countries", "showValues"=> "0", "theme"=> "zune" ) ); $arrData["data"] = array(); // Push the data into the array while($row = mysqli_fetch_array($result)) { array_push($arrData["data"], array( "label" => $row["Name"], "value" => $row["Population"], "link" => "drillchild1.php?Country=".$row["Code"] ) ); } /*JSON Encode the data to retrieve the string containing the JSON representation of the data in the array. */ $jsonEncodedData = json_encode($arrData); /*Create an object for the column chart. Initialize this object using the FusionCharts PHP class constructor. The constructor is used to initialize the chart type, chart id, width, height, the div id of the chart container, the data format, and the data source. */ $columnChart = new FusionCharts("column2D", "myFirstChart" , 600, 300, "chart-1", "json", $jsonEncodedData); // Render the chart $columnChart->render(); // Close the database connection $dbhandle->close(); } ?> <div id="chart-1"><!-- Fusion Charts will render here--></div> </body>
  7. Gauge with XML

    Thanks again Prerana. Could you simplify this to have the colour range within the php page, not from the database please? I'm trying to convert from the old flash version of FC. Thanks. Jamie.
  8. Gauge with XML

    Thank you very much Prerana. That got me going. Can you explain how the colours work please? I can't get any colours across the gauge. I think it's something to do with the $code attribute? Jamie.
  9. Gauge with XML

    Thanks. I have been through those tutorials but it is different for the Angular Gauge. Do you have an example for this please?
  10. Gauge with XML

    Hello. I've been trying all day to do this. Do you have an example of an Angulargauge, getting it's data in XML, dynamically from a database please? Thanks . Jamie.
  11. Inverted Values

    Thanks for the reply. Yes that works ok in the JS Fiddle, but I am using the older Flash charts. As you can see from the photo the x-axis is negative, but the bars go upwards, not downwards from zero. This makes the chart inaccurate. Is there a way in the flash charts to fix this please? Jamie.
  12. Inverted Values

    Hello. My chart data sometimes returns as a -ve value, which is correct. Sometimes Fusioncharts displays the -ve values with an inverted bar, which is correct, but sometimes it displays like a +ve value. See Photo. Is there a way to ensure that -ve values have inverted bars please? Jamie.
  13. SparkColumn High/Low

    It's ok I found the problem. I needed this in the code ---- highColor='00CC33' lowColor='CC0000' Thanks anyway.
  14. SparkColumn High/Low

    I don't really want to pay again for the latest version just to get this feature working. I think it's more likely my code. Can you please check the code I attached? Thanks.
  15. Hello. I have the older Flash version of Widgets. I am trying to get a SparkColumn to show the Highest value id green and the lowest value in red (the same as your examples). All of my values are grey. Can you help please? Thankyou. Jamie.