Hi,
I create a simple math field to calculate GDD from weather data and all works well. But when I aggregate, the box

SELECT THE FIELDS TO USE IN THE FORMULA.

disappears.

Also appears this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_views_simple_math_field' in 'field list'

and in the query appear the fiedd: SUM(field_views_simple_math_field) AS "field_views_simple_math_field"

The issue appears only if I choose a SQL math operation (SUM, AVG and so on) associated to the VSMF field. Instead if I choose "Group" no error appears.

That's due to the fact that your VSMF executes math operations on fields after aggregations? In this case is bettter to "disable" aggragations options for this field (similat to gloabal: custom text)

Thanks, Antonio

Comments

antonio.bertolini created an issue. See original summary.

andileco’s picture

Thank you, @antonio.bertolini - that's a great point; I will disable aggregation options for this field.

  • andileco committed 52f2220 on 3.0.x
    Issue #3302586 by antonio.bertolini, andileco: Disable aggregation...
andileco’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.