Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
I'm working with Format: Views Calc Table in Views so I can't calculate AVG of some fields and I don't understand this error. Can any one help me please.
Comments
Comment #1
TreyeDesigns CreditAttribution: TreyeDesigns commentedI am having the same problem. Looking for a solution / work around. Let me know if you come up with anything.
Comment #2
Karimh CreditAttribution: Karimh commentedI found what was the problem: the views_calc 7.x-1.x-dev can't be used with views 3, it's consist with views 2 so you have to install views 2 first and empty all sql filds table and then install views_calc 7.x-1.x-dev . It works well now. I want to calculate SUM, AVG... by group in views but grouping_by module does not exist yet in drupal 7.
Comment #3
TreyeDesigns CreditAttribution: TreyeDesigns commentedAre you talking about grouping by inside views. You can use "Use aggregation" and set it to "yes" this will group the fields though I personally have not had much luck using this.
You said that Views Calc can only be used with Views 2. However There is only Views 3 for D7, what version of Views are you using to get the Calc module to work properly?
Comment #4
Karimh CreditAttribution: Karimh commentedHi, I'm sorry! I want to say views_calc 7.x-1.x-dev (http://drupal.org/node/67344/release) works properly with Views 7.x-3.0-beta3 ( http://drupal.org/node/1107716).
Comment #5
Karimh CreditAttribution: Karimh commentedI can't see "Use aggregation" in views to group the fields to calculate SUM or AVG. In which place can I find it?
thinks.
Comment #6
sashkernel CreditAttribution: sashkernel commentedSame problem. I use views 3.1 downgrading to beta is not a good solution for me. Does anyone know any other workaround?
Cheers.
Comment #7
CarbonPig CreditAttribution: CarbonPig commentedI'm having the same error issue. Tried testing for a few hours, but can't get it to work. Looking forward to ideas.
Comment #8
KarenS CreditAttribution: KarenS commentedThis part of the code should be working now.
Comment #10
makkon CreditAttribution: makkon commentedreopen
i try dev and 1.0 ->
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_commerce_price.commerce_price_amount' in 'field list'
commerce_price - relationship for content view (drupal commerce)
Comment #11
makkon CreditAttribution: makkon commentedComment #12
quickly CreditAttribution: quickly commentedI am having this issue only if I use global fields and try to apply aggregation functions on them... any solution?
Comment #13
Matt Habermehl CreditAttribution: Matt Habermehl commentedThis problem appears to happen when trying to calculate fields that have been brought into the view via relationships.
Comment #14
spessex CreditAttribution: spessex commentedI'm having exactly the same problem on both recommend release and dev version (D7). Keep getting:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_quote_total_ex_vat_.field_quote_total_ex_vat__value' in 'field list'
As Matt suggests above I have a complicated view with many relationships.
This is module is integral to my whole site unfortunately!
Comment #15
Yuri CreditAttribution: Yuri commentedAny updates on this issue?
Comment #16
skorzhTest please my patch, perhaps it will fix the problem.
https://drupal.org/comment/8342915#comment-8342915
Comment #17
mgiffordOk, there was a change that was committed 11 months ago that might fix this. Let's mark this postponed until we can confirm that this is still a problem.