Search the Community
Showing results for tags 'msline'.
Found 4 results
-
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.. -
-
Dynamic Tooltip for MSLine Compare Between Different Series
WebDevSarah posted a topic in Miscellaneous
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- 2 replies
-
- msline
- plottooltext
-
(and 1 more)
Tagged with:
-
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.