This project is read-only.

Great Work, need little help

Jan 25, 2010 at 8:07 PM

I am a great fan of your work. Several months back you pointed me to this. For me there is a lot to take in and I am not sure where to start. I have come back to this several times over the last several months, but not luck. I have an issue. I am forced to use single line text field to capture data, but data will only be whole numbers. I cannot apply any formulas but count. so I created calc fields to convert the input to INT. So I either need to figure out how to average the results of my grouped, original input, or average the calc fields. If you could provide me a Q&D way to quickly average one calc column, DisplayName is "q01"

I know I need jquery resource

and I think a link to your js, correct?

what would the script look like for the calc column "q01" in a view?

 

thanks Larry

 

Coordinator
Jan 27, 2010 at 8:34 PM

Larry,

This resource will not help you "do anything" with the data, it only gets the data and helps with the calculations.  This is basically straight from one of the examples on Home:

$(function(){
	if (typeof ctx=='object'){
		owsapi({view:"",command:"&Query=*"},function(o){
			var avg = ows.getAvg(o.ctx, 'q01');
                        alert(avg);
		});
	}
});

You probably don't want to alert the average, but whatever you want to do with it needs to take the place of the alert function call made in the callback.