Hi,
Thanks dear for your reply, Dear I am using to this scenario, my JSON
format is different from your’s. Please check the below example & let
me know that how can I handle it. This is not working, please this is
urgent.
/
************************************************************************************************/
$(document).ready(function()
{
loadTimeLineAPI();
});
function loadTimeLine() {
drawChart();
}
function loadTimeLineAPI() {
var a = google.load("visualization", "1", {"callback": loadTimeLine,
packages:["annotatedtimeline"]});
}
function drawChart() {
var myJsonObject = getData();
var rows = [];
if(myJsonObject.length>0)
{
$.each(myJsonObject[0].quotes, function(a,b) {
var dateString = b.datetime;
var volume = b.volume;
var price = b.price;
var cellsArray =
[
{v: dateString},{v: volume}, {v: price}
];
var row = {c: cellsArray};
rows.push(row);
});
}
var chart = new google.visualization.AnnotatedTimeLine
(document.getElementById('div1'));
chart.draw(row, {displayAnnotations: true});
}
function getData()
{
var data = [{
"quotes":[
{"datetime":"03/26/2006","volume":531,"marketcap":8.73E11,"price":
128.56},
{"datetime":"08/26/2006","volume":131,"marketcap":8.301E11,"price":
227.27},
{"datetime":"09/16/2006","volume":231,"marketcap":8.637E11,"price":
325.99},
{"datetime":"08/04/2006","volume":331,"marketcap":8.384E11,"price":
425.28},
{"datetime":"07/11/2006","volume":531,"marketcap":8.065E11,"price":
425.25}]
}];
var p = eval(data);
return p;
}
/
************************************************************************************************/
Thanks
- arsh
On Feb 19, 11:40 pm, VizBoy <[email protected]> wrote:
> Hi,
>
> You need to format your data in a way that fits the Visualization API. It
> does not matter that it's huge with hundreds of rows. It will still work
> just fine if you format it correctly. In your case, instead of what you
> wrote, it should be in the format you used below:
>
> var data = new google.visualization.DataTable({
> cols: [
> {label: 'Date', type: 'date'},
> {label: 'Volume', type: 'number'},
> {label: 'Price', type: 'number'}],
> rows: [
> {c:[{v: new Date(2008, 3 ,26)}, {v:
> 4.482362E7}, {v:28.56}]},
> {c:[{v: new Date(2008, 8, 26)}, {v:
> 4.477303E7}, {v:27.27}]},
> {c:[{v: new Date(2008, 9, 16)}, {v:
> 1.116584E8}, {v:25.99}]},
> {c:[{v: new Date(2008, 8, 4)}, {v:
> 6.040522E7}, {v:25.28}]},
> {c:[{v: new Date(2008, 7, 11)}, {v:
> 6.810552E7}, {v:25.25}]}
> ]
> });
>
> Only with many more rows....
> If you're asking how to do it automatically, you could do something like:
> var rows = [];
> var quotes = myJsonObject.quotes;
> for (var i = 0; i < quotes.length; i++) {
> var quote = quotes[i];
> var dateString = quote.date;
> var dateElements = dateString.split('/');
> var cellsArray = [{v: new Date(dateElements[2], dateElements[0],
> dateElements[1])},
> {v: quote.volume}, {v: quote.price}];
> var row = {c: cellsArray};
> rows.push(row);
>
> }
>
> This code might need some fixing, because I wrote it without testing, but
> this is the general idea. Somehow transform the data that you have into the
> correct form of rows for our API.
>
> Regards,
> VizBoy.
>
> On Thu, Feb 19, 2009 at 7:26 AM, Arshad <[email protected]> wrote:
>
> > My question is that I dont know that how many rows in JSON.. Please
> > check the JSON below:
> > Now my question is that how can I use to this huge JSON data using a
> > variable, please let me know that how can I use it.
>
> > JSON:
> > ----------------------------
> > {"quotes":[{"volume":4.482362E7,"marketcap":2.658073488E11,"price":
> > 28.56,"date":"03/26/2008"},{"volume":4.477303E7,"marketcap":
> > 2.4898309011E11,"price":27.27,"date":"08/26/2008"},{"volume":
> > 1.116584E8,"marketcap":2.3729631507E11,"price":
> > 25.99,"date":"09/16/2008"},{"volume":6.040522E7,"marketcap":
> > 2.3081380704E11,"price":25.28,"date":"08/04/2008"},{"volume":
> > 6.810552E7,"marketcap":2.3516064825E11,"price":
> > 25.25,"date":"07/11/2008"},{"volume":4.949439E7,"marketcap":
> > 2.713915368E11,"price":29.16,"date":"04/02/2008"},{"volume":
> > 5.196673E7,"marketcap":2.4003073E11,"price":26.23,"date":"07/30/2008"},
> > {"volume":8.453531E7,"marketcap":2.663657676E11,"price":
> > 28.62,"date":"03/13/2008"},{"volume":1.029828E8,"marketcap":
> > 1.6270003017E11,"price":18.29,"date":"11/19/2008"},{"volume":
> > 1.173847E8,"marketcap":2.53148925302E11,"price":
> > 27.1999,"date":"02/29/2008"},{"volume":9.736064E7,"marketcap":
> > 1.7888997303E11,"price":20.11,"date":"12/16/2008"},{"volume":
> > 9.992337E7,"marketcap":2.5024818291E11,"price":
> > 26.87,"date":"07/01/2008"},{"volume":7.846461E7,"marketcap":
> > 2.5602242457E11,"price":27.49,"date":"06/06/2008"},{"volume":
> > 5.335511E7,"marketcap":2.835907031793E11,"price":
> > 30.4501,"date":"05/15/2008"},{"volume":9.810299E7,"marketcap":
> > 2.92704521E11,"price":31.45,"date":"04/23/2008"},{"volume":
> > 1.072016E8,"marketcap":2.4169073451E11,"price":
> > 26.69,"date":"09/30/2008"},{"volume":7.60048E7,"marketcap":
> > 2.635661919E11,"price":28.3,"date":"06/05/2008"},{"volume":
> > 7.161478E7,"marketcap":2.738108142E11,"price":
> > 29.4,"date":"05/01/2008"},{"volume":3.137194E7,"marketcap":
> > 1.7986848606E11,"price":20.22,"date":"11/28/2008"},{"volume":
> > 1.463643E8,"marketcap":2.2557198189E11,"price":
> > 24.91,"date":"10/06/2008"},{"volume":5.779424E7,"marketcap":
> > 2.5620869043E11,"price":27.51,"date":"06/30/2008"},{"volume":
> > 6.958495E7,"marketcap":2.7260008611E11,"price":
> > 29.27,"date":"05/08/2008"},{"volume":4.786377E7,"marketcap":
> > 2.714846066E11,"price":29.17,"date":"03/24/2008"},{"volume":
> > 4.964211E7,"marketcap":2.5482647763E11,"price":
> > 27.91,"date":"08/14/2008"},{"volume":7.089988E7,"marketcap":
> > 2.7734986554E11,"price":29.78,"date":"05/13/2008"},{"volume":
> > 9.352937E7,"marketcap":2.766048021E11,"price":
> > 29.7,"date":"05/06/2008"},{"volume":5.979924E7,"marketcap":
> > 2.3536372E11,"price":25.72,"date":"07/31/2008"},{"volume":
> > 8.094768E7,"marketcap":1.7675503551E11,"price":
> > 19.87,"date":"12/03/2008"},{"volume":7.561489E7,"marketcap":
> > 2.6785030668E11,"price":28.76,"date":"05/20/2008"},{"volume":
> > 5.673429E7,"marketcap":2.3702330685E11,"price":
> > 25.45,"date":"07/10/2008"},{"volume":5.203139E7,"marketcap":
> > 2.6244859674E11,"price":28.18,"date":"05/28/2008"},{"volume":
> > 5.219324E7,"marketcap":2.6514945171E11,"price":
> > 28.47,"date":"05/22/2008"},{"volume":6.571854E7,"marketcap":
> > 2.74554979302E11,"price":29.4999,"date":"04/01/2008"},{"volume":
> > 6.825204E7,"marketcap":2.621776266E11,"price":
> > 28.17,"date":"02/19/2008"},{"volume":5.71451E7,"marketcap":
> > 2.6049280521E11,"price":27.97,"date":"06/23/2008"},{"volume":
> > 1.089315E8,"marketcap":1.7453114226E11,"price":
> > 19.62,"date":"11/18/2008"},{"volume":8.153331E7,"marketcap":
> > 2.7930565707E11,"price":29.99,"date":"05/16/2008"},{"volume":
> > 9.001423E7,"marketcap":1.805801319E11,"price":
> > 20.3,"date":"11/12/2008"},{"volume":4.379627E7,"marketcap":
> > 2.713915368E11,"price":29.16,"date":"04/04/2008"},{"volume":
> > 5.712692E7,"marketcap":2.456048817E11,"price":
> > 26.9,"date":"09/03/2008"},{"volume":9.727489E7,"marketcap":
> > 1.7186247036E11,"price":19.32,"date":"11/17/2008"},{"volume":
> > 8.332239E7,"marketcap":2.738113516E11,"price":
> > 29.42,"date":"03/18/2008"},{"volume":3.804101E7,"marketcap":
> > 2.5281781317E11,"price":27.69,"date":"08/18/2008"},{"volume":
> > 6.192222E7,"marketcap":2.0121786126E11,"price":
> > 22.62,"date":"11/03/2008"},{"volume":5.961479E7,"marketcap":
> > 2.7436961178E11,"price":29.46,"date":"05/19/2008"},{"volume":
> > 8.090675E7,"marketcap":2.3280144E11,"price":25.44,"date":"07/24/2008"},
> > {"volume":8.877035E7,"marketcap":2.7204128853E11,"price":
> > 29.21,"date":"05/07/2008"},{"volume":7.753418E7,"marketcap":
> > 2.593855326E11,"price":27.87,"date":"03/07/2008"},{"volume":
> > 1.541066E8,"marketcap":2.0211829128E11,"price":
> > 22.32,"date":"10/23/2008"},{"volume":4.967654E7,"marketcap":
> > 2.6505631878E11,"price":28.46,"date":"06/18/2008"},{"volume":
> > 2.284018E8,"marketcap":1.946927985E11,"price":
> > 21.5,"date":"10/10/2008"},{"volume":7.289955E7,"marketcap":
> > 2.4962221062E11,"price":27.34,"date":"09/11/2008"},{"volume":
> > 6.633051E7,"marketcap":2.3893261E11,"price":26.11,"date":"07/29/2008"},
> > {"volume":5.969326E7,"marketcap":2.333505E11,"price":
> > 25.5,"date":"07/28/2008"},{"volume":1.142839E8,"marketcap":
> > 2.3834020728E11,"price":26.32,"date":"10/03/2008"},{"volume":
> > 1.25272E8,"marketcap":1.8404940537E11,"price":
> > 20.69,"date":"11/24/2008"},{"volume":7.967584E7,"marketcap":
> > 1.8227029077E11,"price":20.49,"date":"11/26/2008"},{"volume":
> > 7.124791E7,"marketcap":1.912548195E11,"price":
> > 21.5,"date":"11/07/2008"},{"volume":4.668658E7,"marketcap":
> > 2.641320924E11,"price":28.38,"date":"03/31/2008"},{"volume":
> > 8.222243E7,"marketcap":2.3419201545E11,"price":
> > 25.65,"date":"09/05/2008"},{"volume":1.051446E8,"marketcap":
> > 2.319094422E11,"price":25.4,"date":"09/22/2008"},{"volume":
> > 9.347177E7,"marketcap":2.2385144088E11,"price":
> > 24.72,"date":"10/20/2008"},{"volume":8.465133E7,"marketcap":
> > 2.4102802284E11,"price":25.88,"date":"07/02/2008"},{"volume":
> > 8.310259E7,"marketcap":2.63387534E11,"price":28.3,"date":"03/17/2008"},
> > {"volume":7.69826E7,"marketcap":2.589095454E11,"price":
> > 27.8,"date":"06/02/2008"},{"volume":1.050604E8,"marketcap":
> > 2.602231608E11,"price":27.96,"date":"03/14/2008"},{"volume":
> > 3.890465E7,"marketcap":2.6990242E11,"price":29,"date":"04/03/2008"},
> > {"volume":5.810064E7,"marketcap":2.5257650616E11,"price":
> > 27.12,"date":"06/11/2008"},{"volume":5.072336E7,"marketcap":
> > 2.4916569597E11,"price":27.29,"date":"08/29/2008"},{"volume":
> > 6.302237E7,"marketcap":2.6375245776E11,"price":
> > 28.32,"date":"05/30/2008"},{"volume":1.49981E8,"marketcap":
> > 1.9496446287E11,"price":21.53,"date":"10/22/2008"},{"volume":
> > 9.108476E7,"marketcap":2.565934386E11,"price":
> > 27.57,"date":"03/06/2008"},{"volume":9.379936E7,"marketcap":
> > 2.3770632375E11,"price":26.25,"date":"10/02/2008"},{"volume":
> > 9.209246E7,"marketcap":2.3227465392E11,"price":
> > 25.44,"date":"09/23/2008"},{"volume":6.012199E7,"marketcap":
> > 2.715776764E11,"price":29.18,"date":"03/20/2008"},{"volume":
> > 7.747199E7,"marketcap":2.3463164E11,"price":25.64,"date":"07/21/2008"},
> > {"volume":8.89146E7,"marketcap":2.3978908392E11,"price":
> > 26.48,"date":"10/01/2008"},{"volume":4.872364E7,"marketcap":
> > 2.719499556E11,"price":29.22,"date":"04/17/2008"},{"volume":
> > 8.253617E7,"marketcap":2.5007872527E11,"price":
> > 27.39,"date":"08/07/2008"},{"volume":4.724656E7,"marketcap":
> > 2.6487005292E11,"price":28.44,"date":"05/27/2008"},{"volume":
> > 5.137294E7,"marketcap":2.5254390438E11,"price":
> > 27.66,"date":"08/25/2008"},{"volume":4.914228E7,"marketcap":
> > 2.712053972E11,"price":29.14,"date":"03/25/2008"},{"volume":
> > 7.800206E7,"marketcap":1.885861476E11,"price":
> > 21.2,"date":"11/11/2008"},{"volume":7.810444E7,"marketcap":
> > 1.7221829328E11,"price":19.36,"date":"12/12/2008"},{"volume":
> > 1.082349E8,"marketcap":2.641320924E11,"price":
> > 28.38,"date":"02/26/2008"},{"volume":4.425166E7,"marketcap":
> > 2.682228384E11,"price":28.8,"date":"06/17/2008"},{"volume":
> > 1.072224E8,"marketcap":1.8689598873E11,"price":
> > 21.01,"date":"12/08/2008"},{"volume":6.702865E7,"marketcap":
> > 2.5844388075E11,"price":27.75,"date":"06/26/2008"},{"volume":
> > 4.361413E7,"marketcap":2.4816136374E11,"price":
>
> ...
>
> read more »
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
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
-~----------~----~----~----~------~----~------~--~---
