Thx a lot for your help, i've tryed something like this :
i use your first example.
This is my xml :
<?xml version="1.0" encoding="utf-8"?>
<Export>
<Columns>
<Dim1>Heures</Dim1>
<Metric1>Visites</Metric1>
<Var1>Visites var</Var1>
<Diff1>Visites Diff</Diff1>
<Rat1>Visites rat</Rat1>
<Metric12>% Visites</Metric12>
<Var12>% Visites var</Var12>
<Diff12>% Visites Diff</Diff12>
<Metric2>Pages vues</Metric2>
<Var2>Pages vues var</Var2>
<Diff2>Pages vues Diff</Diff2>
<Rat2>Pages vues rat</Rat2>
<Metric5>Pages vues / visites</Metric5>
<Var5>Pages vues / visites var</Var5>
<Diff5>Pages vues / visites Diff</Diff5>
</Columns>
<Row Dim1="0h" Metric1="4844" Var1="" Diff1="4844"
Rat1="0,018716288271023" Metric12="0,018716288271023" Var12=""
Diff12="-2147483648" Metric2="143891" Var2="" Diff2="143891"
Rat2="0,101175509354574" Metric5="29,7049958711808" Var5=""
Diff5="29,7049958711808" />
<Row Dim1="1h" Metric1="2974" Var1="" Diff1="2974"
Rat1="0,0114909664157767" Metric12="0,0114909664157767" Var12=""
Diff12="-2147483648" Metric2="9140" Var2="" Diff2="9140"
Rat2="0,00642669906735518" Metric5="3,07330195023537" Var5=""
Diff5="3,07330195023537" />
<Row Dim1="2h" Metric1="1882" Var1="" Diff1="1882"
Rat1="0,00727168755699118" Metric12="0,00727168755699118" Var12=""
Diff12="-2147483648" Metric2="9592" Var2="" Diff2="9592"
Rat2="0,00674451832101432" Metric5="5,09670563230606" Var5=""
Diff5="5,09670563230606" />
<Row Dim1="3h" Metric1="1624" Var1="" Diff1="1624"
Rat1="0,00627482496947591" Metric12="0,00627482496947591" Var12=""
Diff12="-2147483648" Metric2="7336" Var2="" Diff2="7336"
Rat2="0,00515823461248552" Metric5="4,51724137931035" Var5=""
Diff5="4,51724137931035" />
<Row Dim1="4h" Metric1="1506" Var1="" Diff1="1506"
Rat1="0,00581889556898444" Metric12="0,00581889556898444" Var12=""
Diff12="-2147483648" Metric2="9304" Var2="" Diff2="9304"
Rat2="0,00654201401779788" Metric5="6,17795484727756" Var5=""
Diff5="6,17795484727756" />
<Row Dim1="5h" Metric1="1915" Var1="" Diff1="1915"
Rat1="0,00739919323678964" Metric12="0,00739919323678964" Var12=""
Diff12="-2147483648" Metric2="7439" Var2="" Diff2="7439"
Rat2="0,00523065802648306" Metric5="3,8845953002611" Var5=""
Diff5="3,8845953002611" />
<Row Dim1="6h" Metric1="4425" Var1="" Diff1="4425"
Rat1="0,0170973525184304" Metric12="0,0170973525184304" Var12=""
Diff12="-2147483648" Metric2="20688" Var2="" Diff2="20688"
Rat2="0,0145465591143812" Metric5="4,67525423728814" Var5=""
Diff5="4,67525423728814" />
<Row Dim1="7h" Metric1="9232" Var1="" Diff1="9232"
Rat1="0,0356706798757399" Metric12="0,0356706798757399" Var12=""
Diff12="-2147483648" Metric2="55467" Var2="" Diff2="55467"
Rat2="0,0390010631475919" Metric5="6,00812391681109" Var5=""
Diff5="6,00812391681109" />
<Row Dim1="8h" Metric1="17954" Var1="" Diff1="17954"
Rat1="0,0693708174273218" Metric12="0,0693708174273218" Var12=""
Diff12="-2147483648" Metric2="115563" Var2="" Diff2="115563"
Rat2="0,0812569610854231" Metric5="6,43661579592291" Var5=""
Diff5="6,43661579592291" />
<Row Dim1="9h" Metric1="26848" Var1="" Diff1="26848"
Rat1="0,103735530037247" Metric12="0,103735530037247" Var12=""
Diff12="-2147483648" Metric2="210174" Var2="" Diff2="210174"
Rat2="0,14778173411185" Metric5="7,8282926102503" Var5=""
Diff5="7,8282926102503" />
<Row Dim1="10h" Metric1="27323" Var1="" Diff1="27323"
Rat1="0,105570839064649" Metric12="0,105570839064649" Var12=""
Diff12="-2147483648" Metric2="158014" Var2="" Diff2="158014"
Rat2="0,111105954751538" Metric5="5,78318632653808" Var5=""
Diff5="5,78318632653808" />
<Row Dim1="11h" Metric1="25643" Var1="" Diff1="25643"
Rat1="0,0990796408203638" Metric12="0,0990796408203638" Var12=""
Diff12="-2147483648" Metric2="124120" Var2="" Diff2="124120"
Rat2="0,0872737295667533" Metric5="4,84030729633818" Var5=""
Diff5="4,84030729633818" />
<Row Dim1="12h" Metric1="19769" Var1="" Diff1="19769"
Rat1="0,0763836298162373" Metric12="0,0763836298162373" Var12=""
Diff12="-2147483648" Metric2="102729" Var2="" Diff2="102729"
Rat2="0,0722328630733403" Metric5="5,19646921948505" Var5=""
Diff5="5,19646921948505" />
<Row Dim1="13h" Metric1="22112" Var1="" Diff1="22112"
Rat1="0,0854365330819282" Metric12="0,0854365330819282" Var12=""
Diff12="-2147483648" Metric2="111983" Var2="" Diff2="111983"
Rat2="0,078739720094052" Metric5="5,06435419681621" Var5=""
Diff5="5,06435419681621" />
<Row Dim1="14h" Metric1="25458" Var1="" Diff1="25458"
Rat1="0,0983648362517967" Metric12="0,0983648362517967" Var12=""
Diff12="-2147483648" Metric2="116536" Var2="" Diff2="116536"
Rat2="0,0819411162487203" Metric5="4,57757875716867" Var5=""
Diff5="4,57757875716867" />
<Row Dim1="15h" Metric1="22602" Var1="" Diff1="22602"
Rat1="0,0873297992365114" Metric12="0,0873297992365114" Var12=""
Diff12="-2147483648" Metric2="92426" Var2="" Diff2="92426"
Rat2="0,0649884122537604" Metric5="4,08928413414742" Var5=""
Diff5="4,08928413414742" />
<Row Dim1="16h" Metric1="27549" Var1="" Diff1="27549"
Rat1="0,106444059780845" Metric12="0,106444059780845" Var12=""
Diff12="-2147483648" Metric2="89075" Var2="" Diff2="89075"
Rat2="0,0626321903090441" Metric5="3,23332970343751" Var5=""
Diff5="3,23332970343751" />
<Row Dim1="17h" Metric1="15152" Var1="" Diff1="15152"
Rat1="0,0585444260698886" Metric12="0,0585444260698886" Var12=""
Diff12="-2147483648" Metric2="38715" Var2="" Diff2="38715"
Rat2="0,0272220628438354" Metric5="2,55510823653643" Var5=""
Diff5="2,55510823653643" />
</Export>
and this my try, but i dont really understanding how to get the row Dim1
ans row Metric 1 :
<?php
$sxml = simplexml_load_file('chartToday.xml');
foreach ($sxml->Row as $row) {
$hours[] = $row["Dim1"];
$metric[] = $row["Metric1"];
}
$sxml = simplexml_load_file('chartYesterday.xml');
foreach ($sxml->Row as $row) {
$hours2[] = $row["Dim1"];
$metric2[] = $row["Metric1"];
} ?>
<html>
<head>
<script type="text/javascript"
src="https://www.google.com/jsapi";></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart () {
var data = new google.visualization.DataTable();
data.addColumn('Hours', 'Metric1', 'Metrric2');
var options = {
title: 'My test Xhart',
hAxis: {title: 'Hours', titleTextStyle: {color: 'blue'}}
};
var chart = new
google.visualization.AreaChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="chart_div" style="width: 900px; height: 500px;"></div>
</body>
</html>
Do you have any idea ?
thx
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/fxVAN_Wy_OUJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
