Created
May 28, 2013 16:34
-
-
Save belotn/5664076 to your computer and use it in GitHub Desktop.
Generate Google chart From CSV _ DateTime;CCU
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $html ="<html> | |
| <head> | |
| <!--Load the AJAX API--> | |
| <script type=`"text/javascript`" src=`"https://www.google.com/jsapi`"></script> | |
| <script type=`"text/javascript`"> | |
| // Load the Visualization API and the piechart package. | |
| google.load('visualization', '1.0', {'packages':['corechart']}); | |
| // Set a callback to run when the Google Visualization API is loaded. | |
| google.setOnLoadCallback(drawChart); | |
| // Callback that creates and populates a data table, | |
| // instantiates the pie chart, passes in the data and | |
| // draws it. | |
| function drawChart() { | |
| // Create the data table. | |
| var data = new google.visualization.DataTable(); | |
| data.addColumn('datetime','Date'); | |
| data.addColumn('number','CCU'); | |
| data.addRows([ | |
| " | |
| $html += @( get-childitem c:\Path\to\log -Filter Log*.txt | sort LastWriteTime |% { import-csv -Delimiter ';' $_.Name -header @("Horaire","CCU") |% { | |
| $d = [datetime]::ParseExact($_.Horaire, "MM/dd/yyyy HH:mm:ss",$null) | |
| if(-not $_.CCU ){$_.CCU=0} | |
| "[new Date($($d.Year), $($d.Month-1),$($d.Day),$($d.Hour),$($d.Minute),$($d.Second)), $($_.CCU)]" } } ) -join ",`n" | |
| $html+=" | |
| ]); | |
| // Set chart options | |
| var options = {'title':'CCU'}; | |
| // Instantiate and draw our chart, passing in some options. | |
| var chart = new google.visualization.LineChart(document.getElementById('chart_div')); | |
| chart.draw(data, options); | |
| } | |
| </script> | |
| </head> | |
| <body> | |
| <!--Div that will hold the pie chart--> | |
| <div id=`"chart_div`"></div> | |
| </body> | |
| </html>" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment