Search the Community

Hello, I currently evaluating FusionCharts prior to purchasing using the free trial. Thank you for a really good and robust package. I'm wondering if there is a way to "re-animate" when the data is changed. For example, I have a `msline` chart and when the data plots change, I was wondering if it would "re-animate". See attached GIF for example. Thanks, -Mazen

hi i have problem with MSLine chart. here is my database look like: ------------|--------------------------|----------------------------| id | Generator | Date | -------------------------------------------------------------------| 1 | Plant 1 | 2015-12-01 | ------------------------------------------------------------------- 2 |Plant 2 | 2015-12-02 | ------------------------------------------------------------------- 3 | Plant 1 | 2015-12-03 | ------------------------------------------------------------------- here is mycode: <?php $q = intval($_GET['q']); $strQueryCategories = "select distinct DATE_FORMAT(tblmarketable.date,'%c-%d-%Y') as DatePro from tblmarketable where ae = 'juan' and YEAR(date) = YEAR(NOW()) and MONTH(date) = '".$q."' order by DatePro"; $resultCategories = mysql_query($strQueryCategories) or die(mysql_error()); $strQueryData = "SELECT ref, date, gen, SUM(amount) as amount from tblmarketable where ae = 'juan' and YEAR(date) = YEAR(NOW()) and MONTH(date) = '".$q."' group by gen, ref, date order by gen"; $resultData = mysql_query($strQueryData) or die(mysql_error()); $strXML = "<graph legendPostion='' caption='Marketable Sales' subCaption='By Juan' xAxisName='Group By Reference No: ' yAxisName='Amount' showValues='0' formatNumberScale='0' rotateValues='1' theme='fint'>"; $strXML .= buildCategories ($resultCategories, "DatePro"); $strXML .= buildDatasets ( $resultData, "amount", "gen"); $strXML .= "</graph>"; echo renderChartHTML("Charts/MSLine.swf", "", $strXML, "FactorySum", 600, 300, false, true); mysql_free_result($resultCategories); mysql_free_result($resultData); function buildCategories ( $result, $labelField ) { $strXML = ""; if ($result) { $strXML = "<categories>"; while($ors = mysql_fetch_array($result)) { $strXML .= "<category label='" . $ors[$labelField]. "'/>"; } $strXML .= "</categories>"; } return $strXML; } function buildDatasets ($result, $valueField, $controlBreak ) { $strXML = ""; if ($result) { $controlBreakValue =""; while( $ors = mysql_fetch_array($result) ) { echo" "; if( $controlBreakValue != $ors[$controlBreak] ) { $controlBreakValue = $ors[$controlBreak]; $strXML .= ( $strXML =="" ? "" : "</dataset>") . ( "<dataset seriesName='" . $controlBreakValue . "'>" ) ; } $strXML .= "<set value='" . $ors[$valueField] . "'/>"; } $strXML .= "</dataset>"; } return $strXML; } ?> the PLANT 1 (id 1) is correct in the position date, but the problem is the PLANT 2 date become 2015-12-01 that shows in a graph instead of 2015-12-02 and the PLANT 1 (id 3) date become 2015-12-02 instead of 2015-12-03 anyone can help me? regards.. -

Hi all, I am creating a 3 series MSline chart where the tooltip is dynamic using "plottooltext". Is it possible to have it compare between 2 different series' points? example: "seriesname": "National Benchmark", "data": [ {"value": "19.4"}, {"value": "19.2"} "seriesname": "Observed", "data": [ {"value": "18.4"}, {"value": "18.2"} "seriesname": "Actual", "data": [ {"value": "16.4"}, {"value": "16.2"} "plottooltext": "$seriesname: $value% - is X% higher than National Benchmark" I am just trying to avoid parsing through the json and format then append all of these tooltips before the chart renders. Any advice would be greatly appreciated. Thanks, Sarah

Dear who may it be concerned. I face with a problem and I need your help. Please guide me as soon as possible you can 1.How Can I draw a line in a middle of the Chart such as this chart How can I make my Max xAxis to double of data value? 2. I want to use persian font in outCnvBaseFont='b nazanin' and font='b nazanin' but it show only Arial font.