That worked if the next entry has data. Try this, Enter "11/2013" for "This Month" and "10/2013" for "Last Month" and click Submit. Enter "11/2013" for "This Month" and "5/2013" for "Last Month" and click Submit.
Because there is no data for "5/2013", it never enters the .each() loop. http://isaac.issharepoint.com/Web%20Part%20Page/508Dashboard.aspx Any ideas? Everything i've tried doesn't work. Thanks! On Wed, May 28, 2014 at 3:56 PM, Andrew Gallant <[email protected]>wrote: > You need to zero-out the values in anArray and lanArray every time you > return from your AJAX, like this: > > $().SPServices({ > operation: "GetListItems", > async: false, > listName: "508 Dashboard Data", > CAMLViewFields: "<ViewFields><FieldRef > Name='Title'></FieldRef><FieldRef Name='Year'></FieldRef><FieldRef > Name='FileType'></FieldRef><FieldRef > Name='TotalFailed'></FieldRef><FieldRef > Name='TotalPassed'></FieldRef><FieldRef > Name='TotalScanned'></FieldRef><FieldRef > Name='score'></FieldRef></ViewFields>", > CAMLQuery: qry(monthWord, yearDte), //Function to call query > completefunc: function (xData, Status) { > for (var x=0; x < anArray.length; x++) > { > anArray[x].totalPages = 0; > anArray[x].totalPassed = 0; > anArray[x].totalFailed = 0; > anArray[x].score = null; > } > $(xData.responseXML).SPFilterNode("z:row").each(function() { > for (var x=0; x < anArray.length; x++) > { > var fileType = getDte($(this).attr("ows_FileType")); > if (fileType == anArray[x].Title) > { > anArray[x].totalPages = > Number($(this).attr("ows_TotalScanned")); > anArray[x].totalPassed = > Number($(this).attr("ows_TotalPassed")); > anArray[x].totalFailed = > Number($(this).attr("ows_TotalFailed")); > anArray[x].score = > Number($(this).attr("ows_TotalPassed"))/Number($(this).attr("ows_TotalScanned")); > x++; > } > } > }); > } > }); > > > On Wednesday, May 28, 2014 2:42:04 PM UTC-4, TheInnovator wrote: >> >> I have created a table using google charts. >> The problem that I'm having is that the table does not refresh. >> >> Enter in "10/2013" for this month and "9/2013" for last month and click >> submit. >> Now enter "8/2013" for this month and "7/2013" for last month and click >> submit. >> As you will notice, on the second set of entries, the table did not >> refresh. >> >> http://isaac.issharepoint.com/Web%20Part%20Page/508Dashboard.aspx >> >> Is there a table method that permits the table to refresh back to 0? >> >> Thanks >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "Google Visualization API" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-visualization-api/Qs7TF3fuxo8/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
