Can't SUM in Views

Hello,

Are you expecting the output something similar to the attachment? If so, this can be easily achieved using Drupal custom "Views handler".

Hi David,

Thanks for the response. I have a quick question, 'Industry' is nothing but 'Taxonomy term Name' or is it a 'Node Title'?

Hi David,

Thank you.. Let me look into this and fix this issue in other way.. Will get back to you soon

Hi David,

You can achieve the desired results by simply adding the "Default Sort Option" from the "Table Settings", So that the SUM function for computed field works. Also i think the issue might not be related to computed field directly and still i suspects about "Group by" only

Please see if this helps you. I have also attached the image references.

Hi David,

Yes, the config options in the computed articles seems to be same as like above.

Can you do me a favour? Can you please enable the "Show the SQL query" from your views and paste the query here?

Or you can simply paste the screenshot of "Managed Fields" of your content type?

I just wanted to replicate the exact setup of yours, then only I can be able to reproduce/fix this problem

Thanks for your video.

I have exactly replicated your video's scenario in simplytest.me and following is the URL.

https://d08d9.ply.st/admin/structure/views/view/computed_field_view

admin/admin is the drupal credentials.

But somewhat even the default grouping is not working here and the title still showing as duplicate. Can you please check this URL and see whether am missing anything here?

Additionally can you please also let me know your drupal version of

1. Drupal Core
2. Views
3. Computed Field

Hi,

Thank you.. Now i can clearly reproduce the issue. Let me investigate and get back with a feasible solution.

Cheers

Hi David,

The issue has been resolved now by introducing the "Custom field handler for computed field" and I have attached the screenshot.

I will share the files associated with this later.

Note : Can you please share your email address? it's hard for me to track it here.

Hi David,

I have uploaded the patch file "computed_field" which will create a custom views field handler named as "Computed Field Handler". This will read the consolidated values from the "computed field" and rendered it separately.

Hi David,

Am not sure about the field length with respect to the custom field handler.

Let me inspect with longer field names and see how it's goes..

Additionally if you are trying with a longer field name say field_test_this_timesheet, I guess this field should be already available in view as the part of computed field..

Thanks David. Glad to hear that the patch is working.

This looks like a nice addition but introduced some code standard issues for whitespace and dsm commented out is in there too.

+++ b/computed_field.module
@@ -510,3 +510,81 @@ function _computed_field_compute_value($entity_type, $entity, $field, $instance,
+  ¶
...
+	
+	
...
+	  '#required' => TRUE,
...
+	  //dsm($this->view->field);
+	
+	if (isset($this->options['computed_field_name']) && $this->options['computed_field_name']) {
+		$field_data = 'field_data_'.$this->options['computed_field_name'].'_'.$this->options['computed_field_name'].'_value';
+		return $values->{$field_data};
+	}
+	return NULL;
+   ¶

Whitespace cleanup and leftover DSM

Added a follow-up with patch #3128775: Coding Standards from PHPCS and commented dsm() left in code