See here for what I am working on:
http://www.goflyxc.com/results/2363
- The "Sum" column (in both the page and the block on the right) should show a sum of all 7 tasks (T1-T7)
- Sum's field is a computed field that is set to store the data in the database as an integer
- I created the nodes (imported them actually) with values in the first three columns and the page sum was calculated properly and the Sum column in the Page sorted properly
ISSUES:
- after adding two values in Stewart's T6 and T7 and it didn't recalculate the Sum
- it also brought Stewart from the bottom of the sort to the top of the sort. Even after a resort, it keeps Stewart at the top.
- the Block is set to just show the name and Sum....but the total as you see shows zero for everyone. I thought that since the value is stored in the database, this should show the proper total.
So does this module only do one calculation and never update the value stored in the database?
Comments
Comment #1
willwade commentedI *think* what you are trying to do is broken in 5.. I could be wrong though..
In 5 computed field is pretty bust on Display Field.. Its something that I never used myself.. read moonshine's comment in regard to version 6: http://drupal.org/node/236963#comment-940562
As I say I could be wrong - just thought I would mention it since I just read Moonshines comment this morning and seems mighty similar
Comment #2
mdowsett commentedso...in a nutshell, is the v5 version abandoned? I am doing the simplest of computations and it isn't working. It seems that I am doing something wrong.
I've messed with the table a bit...the latest rendition is at:
http://goflyxc.com/results/2128
the sum column in the table should show the same values as in the block on the right sidebar...they are the same views field but the sidebar shows zeros for everyone (even tho the sort order is correct which is bizarre)
Comment #3
willwade commentedI wouldn't say "abandoned" - agileware don't appear to be doing any work on computed field anymore & there is a discussion in the drupal 6 port thread about who will take over the maintenance of it. Feel free to put your hand up if your willing to help! I myself have limited time to do any huge amount of work - its most likely going to be a collaborative effort..
Comment #4
mdowsett commentedI'm no coder so I am of limited help other than testing, documenting and suggesting things!
I am assuming that this module is rather limited in the calculations it can perform...not due to the programming but I suppose to the limitations of a browser...? It seems that it does one calc at a time (per row)???
I was hoping that it could take columns, add them together to create a sum and sort them from highest to lowest - this isn't an issue...but then I was hoping calculate a percentage of each of the rows compared to the highest sum in the view.
Is this possible? I could see it being rather taxing on the server and it take a bit to show the view but the # of nodes in the view would be no more than 100.
Comment #5
colanVersion 5 is no longer supported.