I am using Views along with Highcharts Module.
Here is my objective:
I have some integers that are contained in nodes 3 different integer fields to be exact. These integers occur over a duration of time and are entered on various days.
What I am trying to do is sum all the integers that happen on the same day.
Example:
Day 1 - 5/24/12 node #1 integer field: 10 node #2 integer field: 10 node #3 integer field: 10 node #4 integer field: 10 node #5 integer field: 10 Day 2 - 5/30/12 node #1 integer field: 20 node #2 integer field: 20 node #3 integer field: 20 node #4 integer field: 20 node #5 integer field: 20
Desired output of data for highcharts would be:
Day 1 - 5/24/12 integer field: 50 Day 2 - 5/30/12 integer field: 100
I have tried to use grouping and aggregation but I could not get a desired display. I could get all nodes to display but could reduced them down to the desired result.
Please let me know if I can clarify in any way or if this is even possible
thanks!