I cannot get proper results from View PHP field.
I’ve set up a Flipped Table view of entity form submission of which I’m trying to calculate “results” (sum and count(for avg)) with following code
$results = array(); // For results
$static = get_object_vars($row);
dsm($static);
foreach($static as $key => $value) {
if(strpos($key,'field_') !== FALSE){
if($value !== NULL){
$results[$static['entityform_id']]['count']++; // Count no. of fields
$results[$static['entityform_id']]['sum']= $results[$static['entityform_id']]['sum']+$value; // Count sum of field values
}
}
}
return json_encode($results[$static['entityform_id']]);
which results:
{"count":55,"sum":55} {"count":55,"sum":110} {"count":55,"sum":165} {"count":55,"sum":220}
At this point I do not understand that why sum is always row index * sum? Eg.1 =55, 2=110, 3=165… All the submissions have the same fields and field values (clones) which explaines sums but I can’t figure out that where this multiplication “logic” happens?
It seems like it is looping/counting all four result rows every time.
