[xsl] Help XSL Transformation of Data

[Rajesh Jain <rjain15@xxxxxxxxx>]

Hi

I need help to transform the XML data to plot a graph. 

The metrics data has to be pulled outside and organized by Time. 

The Metric Counter names (CPU, Disk, Memory) are dynamic, I mean, I could get five metrics next time.

Please tell me how to pull data by the Names and organize by Time.





<Chart-Data> 
<Root> 
  <Item ID="Server"> 
   <Statistics > 
        <Item Time="1253419200000"> 
          <Metrics> 
             <CPU TotalValue="20.0"/ > 
             <Disk TotalValue="10.0" / > 
             <Memory TotalValue="20.0" / > 
          </Metrics > 
        </Item > 
        <Item Time="1253419211000"> 
          <Metrics> 
             <CPU TotalValue="40.0"/ > 
             <Disk TotalValue="60.0" / > 
             <Memory TotalValue="10.0" / > 
          </Metrics > 
        </Item > 
    </Statistics> 
  </Item> 
</Root> 
<Chart-Data> 

This has to be Transformed in this XSL output 

<chart_data> 
                <row> 
                        <null/> 
                        <string>10</string> 
                        <string>11</string> 
                </row> 
                <row> 
                        <string>CPU</string> 
                        <number >20</number> 
                        <number >40</number> 
                </row> 
                <row> 
                        <string>Memory</string> 
                        <number>20</number> 
                        <number >10</number> 
                </row> 
                <row> 
                        <string>Disk</string> 
                        <number >10</number> 
                        <number>60</number> 
                </row> 
</chart_data>

Thanks

Rajesh