Aggregate function

[David Doret _Admin_]

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.

[Natalie Paramonova [Stiltsoft]]

Hello David,

You can try to use the ConfiForms app in combination with the Pivot Table macro bundled in the Table Filter and Charts app. With the help of this macro, you can aggregate data from your resulting table in a pivot table and perform calculations.

[Alex Medved _ConfiForms_]

How well does it work with Confluence cloud and the missing feature of the new Confluence editor - nesting the bodied macros (which you need to have in order to get the results from ConfiForms)?

[David Doret _Admin_]

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_]

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_]

Ooops, sorry, this was the wrong forum :-)

[Alex Medved _ConfiForms_]

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