Search the Community

Hello everybody! I have two questions concerning xAxis Label of MSLine2D charts.. First of all : - How do I manage the display of labels on xAxis? I've already tried the labelStep attribute to the <chart> tag : <chart caption='AverageProcess time' stepLabel = '7'> But it goes on rendering ALL the label from the <category> tag. My second question is more SQL-PHP side : - I set my categories label from a database, where all the dates for a process start are set. So, for every process, there is a lot of dates. but in my SQL query, i wrote : SELECT p.DateStart, p.Name, p.Id FROM processes ORDER BY (p.Name, ASC) That gives me a chart with xAxis label like : '23/04/2013' '25/04/2013' '27/04/2013' (which is for the first process) followed by : '22/04/2013' '23/04/2013' 25/04/2013' (which is for the second process) So, i would like to render my labels by chronological order. How do i do that? by SQL (on Oracle database), by PHP or by XML?? Thanks by advance!

Hi everybody, I try to render a multi series line chart in my page, using 3 php files : - index.php, wich contains a form to pick up some elements (processes executed in the month, and a period -last hour, last day..), - processCharts.php, which treat the informations from the form and call the function "renderchartAvgSum(()" - chartCreation.php, in which i defined the function "renderchartAvgSum()" and which uses "renderChartJS()" from FusionChart. let's see this : chartCreation.php <?php require_once("/FusionChartPath/FusionCharts_Gen.php"); /* function renderchartAvgSum() : * $chartType : the Chart we want to build. MSLine, Line etc... * $pID : lists of process Ids to find in the database * $step : step of xAxis in the cahrt * $diffDate : difference in days between $endDate -today- and begin date of process * $endDate : ending date of process . generally = SYSDATE * $queryValue : what we need (avg by wich time?) * $graphW, $graphH : dimensions of chart. */ renderchartAvgSum($chartType,$pID,$step, $diffDate, $endDate, $chartName, $queryValue, $graphW, $graphH){ if(!empty($processList)){ } ?> blabalaaa

Hi everybody, I try to render a multi series line chart in my page, using 3 php files : - index.php, wich contains a form to pick up some elements (processes executed in the month, and a period -last hour, last day..), - processCharts.php, which treat the informations from the form and call the function "renderchartAvgSum(()" - chartCreation.php, in which i defined the function "renderchartAvgSum()" and which uses "renderChartJS()" from FusionChart. let's see this : chartCreation.php <?php require_once("/FusionChartPath/FusionCharts_Gen.php"); /* function renderchartAvgSum() : * $chartType : the Chart we want to build. MSLine, Line etc... * $pID : lists of process Ids to find in the database * $step : step of xAxis in the cahrt * $diffDate : difference in days between $endDate -today- and begin date of process * $endDate : ending date of process . generally = SYSDATE * $queryValue : what we need (avg by wich time?) * $graphW, $graphH : dimensions of chart. */ renderchartAvgSum($chartType,$pID,$step, $diffDate, $endDate, $chartName, $queryValue, $graphW, $graphH){ if(!empty($processList)){ } ?>