Is there a way to refresh Google Charts periodically in the background?

[Thomas Wang]

Is there a way to refresh Google Charts periodically in the background?  Thanks.

[asgallant]

If you have your data pulled from an AJAX source (either custom or Google spreadsheets), then yes, you can update the data on whatever interval you choose.

[Thomas Wang]

My data source is a JSON file.  If yes, could you please tell me how to do that?  Thanks.

[asgallant]

What code are you using to fetch the data?

[Thomas Wang]

Here is my site: http://collectiveintel.info

My two js file are located at http://collectiveintel.info/js

Please take a look.  For now I need to press F5 to refresh, I want to reload it periodically like every 1 minute.  Thanks.

[asgallant]

Try using this as your main.js:

function loadCharts() {
    // do these variables need to be in scope here? 
    var ctime, cpo, cpc, cph, cpl;
    load1();
    load2();
    
    function load1 () {
        $.getJSON("http://collectiveintel.info/json/tindex.json", function(json) {
            buildChart(json);
            // call load1 after 60000ms (1 min)
            setTimeout(function () {
                load1();
            }, 60000);
        });
    }
    
    function load2 () {
        $.getJSON("http://collectiveintel.info/json/current.json", function(json) {
            ctime = json.current_hour[0]["Activity_Time"];
            cpo = json.current_hour[0]["Price_Open"];
            cpc = json.current_hour[0]["Price_Close"];
            cph = json.current_hour[0]["Price_High"];
            cpl = json.current_hour[0]["Price_Low"];
            
            document.getElementById("tdCurrentHighPrice").innerHTML = cph;
            document.getElementById("tdCurrentOpenPrice").innerHTML = cpo;
            document.getElementById("tdCurrentClosePrice").innerHTML = cpc;
            document.getElementById("tdCurrentLowPrice").innerHTML = cpl;
            document.getElementById("thCurrentActivityTime").innerHTML = ctime + " (GMT)";
            
            $.getJSON("http://collectiveintel.info/json/pivotp.json", function(json) {
                buildPivot(json, parseFloat(cpc));
                
                // call load2 after 60000ms (1 min)
                setTimeout(function () {
                    load2();
                }, 60000);
            });
        });

[asgallant]

What are you using for your data source?

On Monday, June 4, 2012 2:25:20 PM UTC-4, Takashi SASAKI wrote:

I'm using ChartWrapper.

When I call ChartWrapper#draw for the first time, it work and a chart shows.

But at the second call, the chart does not refresh.

setRefreshInterval works only if I use Google Spreadsheet as a data source.

How can I redraw charts with ChartWrapper?

[Takashi SASAKI]

I inspected (sniffed) server/client request and responses and found that

my data source always responses with "reqId" : "0" even if GVIZ script 

periodically calls with incrementing  reqId such as tqx=reqId%3A1, tqx=reqId%3A2 and so on.

My data source depends on GVIZ data source Python library

https://developers.google.com/chart/interactive/docs/dev/gviz_api_lib 

and that fixed reqId behavior is because of the gviz_api library.

I'm going to fix it but .. zzz ... just before the dawn ...

[Takashi SASAKI]

Wow, I was a fool.

In gviz_api, ToResponse function takes tqx parameter and processes it.