mpaul

The problem is that the individual elements are not plotting as per time line. So" rysnc" element items happening at 2 AM each day does not plot for all the 3 days in the timeline . It plots only of the one day on the left ( i.e. first day in the time line and does not show up at the other two days at the same time slot ( 2Am to say 4 AM ) in the time line. The data shows that it exists in the xml dump too. This data as you see is discontinuous unlike the dataserver item which exists all across the time line since its the main process on this host etc. Interestingly enough the behavior is same for any number of days you choose .. so its correct for 1 day and does not work for any extended period of days after that . So my graph is correct if my date interval f is 1 days in my mysql query., Trying to explain the chart in words :- Time line -> day 1 ( 12 Am -> 11:59:59 Pm ) -------- day 2 ( 12 Am -> 11:59:59 Pm ) ------ day 3 ( 12 Am -> 11:59:59 Pm ) ------------ Items ( stacked below ) Dataserver ------------- exists ------------------------------------------- exists ------------------------------ exists ( all cross the time lines ) and does show up in the chart sshd ------------ exists (2am to 5 AM ) ------------------------- exists (2am to 5 AM ) ------------------ exists (2am to 5 AM ) ---------------------------- shows up for 1 day in the chart rsync ------------- exists (2am to 3:30 AM ) ------------------ exists (2am to 3:30 AM ) -------------- exists (2am to 3:30 AM ) ---------------------- shows up for 1 day in the chart So sshd and sync is not getting plotted in its time periods each day. ( i.e. it does only show up for the first day and not the other days in the time periods as it occurred ) I hope I could explain the issue now.

So I turned on the debug for the chart and it shows the version to be Version: 3.2.2(XT) and here's the dump from the debug screen . data_new.txt I would really appreciate any help on this. data_new.txt

In short the data for the rsync looks like : <dataset seriesName='rsync' color='FF0000'> <set value='98.89'/><set value='99.29'/> <set value='99.95'/><set value='99'/><set value='97.91'/> <set value='98.98'/><set value='98.89'/><set value='98.9'/> <set value='97.92'/><set value='98.99'/><set value='97.94'/> <set value='99.02'/><set value='99.83'/><set value='99.93'/> <set value='98.96'/><set value='99.93'/><set value='99.95'/>' <set value='99.97'/><set value='99.87'/><set value='97.89'/> <set value='97.94'/><set value='98.89'/><set value='97.89'/> <set value='98.78'/>

Thanks.. Looks to be a issue with discontinuous data points I just could copy out the xml part from page source . into the attached txt file data.txt I tried using the SimpleXMLElement to var_dump the xml string.. but to no avail. I am using this code from the code examples to create my str_XML /*********************************************************************************************** * Function to build XML for datasets that will contain chart data * @param $result Database resource. The data should come ordered by a control break field which will require to identify datasets and set its value to dataset's series name * @param $valueField Field name as String that contains value for chart dataplots * @param $controlBreak Field name as String that contains value for chart dataplots * * @return Dataset XML node */ function buildDatasets ($result, $valueField, $controlBreak ) { $strXML = ""; if ($result) { $controlBreakValue =""; while( $ors = mysql_fetch_array($result) ) { if( $controlBreakValue != $ors[$controlBreak] ) { $controlBreakValue = $ors[$controlBreak]; $strXML .= ( $strXML =="" ? "" : "</dataset>") . ( "<dataset seriesName='" . $controlBreakValue ."' color='" . getFCColor() . "'>" ) ; } $strXML .= "<set value='" . $ors[$valueField] . "'/>"; } $strXML .= "</dataset>"; } return $strXML; }

Attaching 2 more snips of the same data timeline..

We are testing the fusion charts trial version for our sysadmin graphs . Facing issues with displaying all the data points for all the items . Background: We have captured the nmon output into mysql tables and my query shows all the data points for each control break. Issue : When I render using ScrollStackedColumn2D.swf it only displays a part of the data. Is this because this is the Trial Version .. how to test /view the data showing up all across the time line.. here// I need to test out all the aspects before we can proceed to purchase .. Snip : please note the rsync values : which shows perfectly on the left sides here. ( chart_left.jpg ) but vanishes when I scroll to the right ..(chart_right.jpg ) The mysql data from query looks like : query : select Command as Process, ZZZZ as TimeStamp , CPU_PCT FROM nmon.top where ZZZZ = FROM_UNIXTIME(UNIX_TIMESTAMP(ZZZZ)- UNIX_TIMESTAMP(ZZZZ)%(30*60)) and hostname = 'wkr-sybase01' and ZZZZ >= DATE_SUB(current_date(),INTERVAL 3 DAY) and Command not like '%wq%'[attachment=5778:chart_left.JPG] and CPU_PCT > 5 group by Command ,ZZZZ order by Command ; output : data jpg php code : // SQL query for category labels unset ( $top_strQueryCategories ,$top_resultCategories , $top_strQueryData , $top_resultData , $top_strXML ) ; $top_strQueryCategories = " select distinct ZZZZ as TimeStamp FROM nmon.top where ZZZZ = FROM_UNIXTIME(UNIX_TIMESTAMP(ZZZZ) - UNIX_TIMESTAMP(ZZZZ)%(\"$PERIOD\")) and hostname = \"$HOST\" and ZZZZ >= DATE_SUB(current_date(),INTERVAL \"$INTERVAL\" DAY) and CPU_PCT > 5 and Command not like \"%wq%\" group by ZZZZ , Command order by ZZZZ ; "; // Query database $top_resultCategories = mysql_query($top_strQueryCategories) or die(mysql_error()); // SQL query for timeseries data $top_strQueryData = " select Command as Process, ZZZZ as TimeStamp , CPU_PCT FROM nmon.top where ZZZZ = FROM_UNIXTIME(UNIX_TIMESTAMP(ZZZZ) - UNIX_TIMESTAMP(ZZZZ)%(\"$PERIOD\")) and hostname = \"$HOST\" and ZZZZ >= DATE_SUB(current_date(),INTERVAL \"$INTERVAL\" DAY) and CPU_PCT > 5 and Command not like \"%wq%\" group by Command ,ZZZZ order by Command "; // Query database $top_resultData = mysql_query($top_strQueryData) or die(mysql_error()); //We also keep a flag to specify whether we have to animate the chart or not. //If the user is viewing the detailed chart and comes back to this page, he should not //see the animation again. //$strXML will be used to store the entire XML document generated //Generate the chart element $top_strXML = "<graph bgColor='CCCCCC' showBorder='1' showLabel='1' caption='TOP cpu processes for host : $HOST for last $INTERVAL day(s) ' subCaption='Every $PERIODmin Mins' xAxisName='TimeLine' yAxisName='CPU UTIL %' showValues='0' formatNumberScale='0' rotateValues='1' animation='1' interactiveLegend='1' showSum='1' showToolTip='1' labelDisplay='rotate' >"; // Build category XML $top_strXML .= buildCategories ($top_resultCategories, "TimeStamp"); // Build datasets XML // function buildDatasets ($result, $valueField, $controlBreak ) $top_strXML .= buildDatasets ( $top_resultData,"CPU_PCT" ,"Process" ); //Finally, close <chart> element $top_strXML .= "</graph>"; //Create the chart - MSLINE 3D Chart with data from strXML // FC_SetRenderer("javascript"); // echo renderChart("Charts/StackedColumn3D.swf", "", $top_strXML, "TOP", 1200, 600, false, true); echo renderChart("Charts/ScrollStackedColumn2D.swf", "", $top_strXML, "TOP", 1200, 600, false, true); // Free database resource mysql_free_result($top_resultCategories); mysql_free_result($top_resultData); Thanks in advance , any suggestions welcome.. mpaul