Support relationships with calculated fields

You are using values from a relationship? That is not currently working. It's going to be tricky because I have to find the right table name to swap into the query. I'm spending some time on this today. Not sure if I'll find a fix right away.

Renaming for clarity.

subsribing

Any progress regarding that in the dev version ?

+1 here!

It would be nice to have relationship calc working... Is there any chance to get this?

bump

Subscribing.

@johnthomas00 Could you explain your solution? Were you able to calculate fields in a view using that module?

Okay I have a workaround.

Using the views_customfield module, you can add a customfield to your view that can contain PHP. I first put the following code into the customfield and viewed it to find the string name I needed:
<?php print_r($data);?>

One you have the string, just replace the above code with this in the customfield:
<?php echo $data->string_name; ?>

I should note also that this didn't work unless I already had the relationship field pulled in above the customfield in the fields section of my view. Since I don't want it to display twice I just set the first instance to not display. I hope that makes sense. Here is a screenshot of the relevant section:

https://img.skitch.com/20110406-rp4peran187cnacqwsgg2b2799.jpg

Also, you need to be using views_customfield dev and install the patch from here: http://drupal.org/node/576264

I imagine a similar approach could be used to build in support for relationship fields out of the box. I think if you need more flexibility the views_customfield module could also entirely replace the functionality of views_calc.

Can #11 be copied to the front page of this module? I find myself referring back to it regularly, both for the fix to the relationship issue, but also to remember how to use print_r($data) to find the field names (I am not a php programmer, so this is not obvious to me).

Hi: I change line 207 (query_total) in views_calc_table.inc
from: $query_field = substr($field->field, 0, 3) == 'cid' ? $field->definition['calc'] : $field->table .'.'. $field->field;

to: $query_field = substr($field->field, 0, 3) == 'cid' ? $field->definition['calc'] : $field->table_alias .'.'. $field->field;

then sum works fine. I change in a view with two relationship nested and works fine, but it needs more tests to check if this is the right solution.

I didn't test for query_sub_total yet.

Regards

Thank you so much for your findings.
I did the changes you suggested and now the results are coming perfectly in both total and sub-total.

Can we somehow apply this to D7 version?

+1 for a Drupal 7 solution, thanks...

#13
View Calc 6.1 dev
Applied #13 patch but Doesn't works on D 6.28 and Views 6.x-3.0

#13
Now applied patch to View Calc 6.x-1.3 on D 6.28 and Views 6.x-3.0.
Works fine now, thanks

Still broken for field handlers.

I set this to be a feature request, as it is not really a bug per se. It would be a valuable feature.

As a project manager
I would like to calculate time spent on activities for projects
given that there is a project content type
and that there is an activity content type
and the activity content type has a decimal field called 'hours'
and that the activity content type has a relation field called 'related project'

Scenario: Creating a view with total hours
A new view is created showing a table activities related to a project
The activities table has a column for the decimal field 'hours'
The views calc style is able to perform various calculations on the hours results for the view query

Note: the view query should contain sufficient details regarding the database fields involved in the relationship
Here is an example page:
http://growhost.org/project/akgillespie

Test please my patch, perhaps it will fix the problem.
https://drupal.org/comment/8342915#comment-8342915

Latest dev version should be working. The zip file does not seem to be getting updated but the git checkout should work right.