It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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.

2 answers

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.

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)?

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. :-(

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

Screenshot 2020-02-08 at 13.11.33.png

More operations we support

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

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

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,340 views 6 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you