add calc fields in grouping data in a list

[joomlamate]

hello,
is it possible to create something like in the screenshot ?

 

[joomlamate]

So far, I am coming with the sum, but it shows me under each group the sums for every field it is split on (screenshot).

 

[joomlamate]

ok, I just don't need to split on and it sums below each group

 

[joomlamate]

This issue appeared again, even though the split on setting is none.
I want to show sum, below each grouped user, but instead it shows all sums for all users under each user grouped row.

 

[joomlamate]

it looks like there is an issue when it sums on group of db joins fields.

 

[cheesegrits]

Hmm, that was an issue we fixed a while back, where grouping on a join element would cause the calculations to show all group'ed results, not just the one for "that" group. But that was fixed a while back.

Can you just confirm this isn't an "old" version (more than a couple of months)?

-- hugh

 

[joomlamate]

Surely it is not an old version. My version is a Git download of a few weeks old.

 

[cheesegrits]

I really really thought we'd fixed this, and on my test table where I group on a join, the calculations work. Can you check your ./components/com_fabrik/models/element.php, around line 4730 should be this comment:

/**
* In the calculation rendering, in default.php, we are keying by values not labels for join elements,
* so there's no point keying by label for joins.  So I think we need to change this chunk so it just tests to see if
* there is a getJoinValueColumn method, and if so, use that.  I'm leaving the original code intact though,
* while I wait to see if this causes Other Horrible Things To Happen.
*/

... followed by a commented out chunk of code.

If you have that comment, then I'll need to get my hands on your server and put soe debug code in, see what's going on.

-- hugh

 

[joomlamate]

This comment exists and below that comment there are a few lines of code commented out.
Now if you really need to check this on my server, then you have to give me some time, because since my last post, I have done many steps to overcome this (created another field - i think a calc one- which returns the value of the db join field, and then I sum over the calc field).

Moreover, the access info in my sites, is different now.

Also, if you are going to check this one, and since I am very close to complete the current project, I would appreciate if you could have a look at a few remaining issues I have, alongside with this one:

1. Filter based on a RadioList element from a joined table (http://fabrikar.com/forums/index.ph...ed-on-a-radiobutton-element-misbehaves.38254/)

2. DB Join element - Autocomplete not working (http://fabrikar.com/forums/index.ph...tocomplete-locked-still-problem-for-me.38247/)

3. And how to add a tab for a new group created in another list to another list/form that is joined to the first list. (http://fabrikar.com/forums/index.ph...-table-in-the-form-of-the-master-table.38238/)

Just let me know when it will be convenient for you to check it, so I will prepare the setup for you...