Method: QuickBase::Client#applyDeviationToRecords

Defined in:
lib/QuickBaseClient.rb

#applyDeviationToRecords(dbid, numericField, deviationField, query = nil, qid = nil, qname = nil, clist = nil, slist = nil, fmt = "structured", options = nil) ⇒ Object

Query records, get the average of the values in a numeric field, calculate each record’s deviation from the average and put the deviation in a percent field each record.



4127
4128
4129
4130
4131
4132
4133
4134
4135
4136
4137
4138
 
# File 'lib/QuickBaseClient.rb', line 4127

def applyDeviationToRecords( dbid, numericField, deviationField, 
                                             query = nil, qid = nil, qname = nil, clist = nil, slist = nil, fmt = "structured", options = nil) 
   fieldNames = Array[numericField]
   avg = average( dbid, fieldNames, query, qid, qname, clist, slist, fmt, options )
   fieldNames << "3" # Record ID#
   iterateRecords( dbid, fieldNames, query, qid, qname, clist, slist, fmt, options ){|record|
      result = deviation( [avg[numericField],record[numericField]] )
      clearFieldValuePairList
      addFieldValuePair( deviationField, nil, nil, result.to_s )
      editRecord( dbid, record["3"], fvlist )
   }
end