easiest way to get total

Hannes · Aug 9th, 2011, 9:22 AM

Hei,

because of the flood of new features in the last months, I am not sure in which Forum to put this request...
(if it is a new feature request, or already simple to realize with the core/api or one of the module):

I have a form field "weight" with is giving the weight in kg.
And I have a form field "group" with is separting the submissions in "A", "B", "C".

What I want now is to have a realtime overview of the total kg for all submissions and the possibility to filter the totals by group:

Code:
submission | group | weight

1 | A | 3

2 | B | 2

3 | A | 1

4 | A | 5

5 | C | 0

total kg: 11

A kg: 9

B kg: 3

C kg: 0

What is the simplest way to get this information inside the formtools User Interface?

Hannes.

***Ben*** · Aug 9th, 2011, 10:45 AM

Hi Hannes,

Good question...!

What would be the ideal format for the results? A table, like you wrote up, or a visualization of some form - like bar charts? The reason I ask is that a couple of weeks ago I was working on an upcoming module ("Data Visualization") that would allow for this - it lets you construct summaries of entire form content: pie charts, bar and line graphs. It's definitely not ready for prime time, but I was just wondering if that would be a preferable format for the data.

- Ben

Hannes · Aug 9th, 2011, 12:14 PM

Hello Ben,

Quote:What would be the ideal format for the results? A table, like you wrote up, or a visualization of some form - like bar charts? The reason I ask is that a couple of weeks ago I was working on an upcoming module ("Data Visualization") that would allow for this - it lets you construct summaries of entire form content: pie charts, bar and line graphs. It's definitely not ready for prime time, but I was just wondering if that would be a preferable format for the data.

Yehaw!... Great to hear the data visualization is already in work!
I hope it will be easy to implement to external sites. This would be cool to present the collected data also outside formtools.

What I currently need should be as simple as possible and inside formtools. The best would be a calculation tool below the view where you can select the field and chose between selected and all (just like it is now in the export manager just with an direct ouput for the result).
Instead that the user needs to go manually through the records and use a calculator. Smile

Any ideas?

Have a nice evening,
Hannes.

FORUMS