Aggregate function

Question

I use Confluence Cloud with Confiforms. My need is simple: display basic calculation results over confiform data.

I have a form F. It has a radio field R with options 1=a,2=b,3=c.

I would like now to display on my page the average value of field R over all records of form F.

I feel stupid because I spent several hours looking through the documentation, examples and forum questions but couldn't get it working. I couldn't even clearly understand which macro I should use to display the value.

Thanks in advance for your assistance.

Alex Medved _ConfiForms_ · Answer

That Atlassian decision we cannot understand either - and instead of improving our cloud app and filling the feature gaps between the server and cloud version we had to spend last year adopting this new editor...

So, in ConfiForms cloud you can use ConfiForms ValueView and do some basic calculations (averages, totals, simple formulas). Everything is calculated per ROW and then aggregated

The example below calculates the average for "num" field

More operations we support

https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions

David Doret _Admin_ · Answer

The apps are great. But unfortunately, the  impossibility to best macros makes them of no use. I bang my head against the walls not understanding why macro nesting is no longer supported. :-(

Alex Medved _ConfiForms_ · Answer

No worries, adding the same comment I left in our support channel (JSD)

--

ConfiForms cloud does not have the TableViewMerger macro as of now. This is the one that can help here, but it is available on server/data center only

You can always go for https://wiki.vertuna.com/display/FORMS/REST+API+for+ConfiForms+CLOUD for calculations or exporting your data in CSV/Excel