How can I show responsive count instead of numeric values in Confiforms TableView?

[Nicole Uschman]

I’ve created a survey in Confluence using ConfiForms with radio buttons, allowing users to rate a question on a scale from 1 to 6. I’m using the ConfiForms TableView macro in combination with the Chart from Table macro to display the results as a bar chart.

Here’s the issue:

The chart treats the selected values (1–6) as numerical values and calculates percentages based on the value itself, not on how many times each option was selected. For example, if one user selects 1 and another selects 6, the chart shows 85.7% for 6 and 14.3% for 1, even though both were selected just once.

What I want is a chart that counts how many users selected each option (1–6) and displays the percentages based on the number of responses, not the numeric value.

Is there a way to tell the chart to treat the values as categories/text rather than numbers? Or how can I properly aggregate the count of selections per value?

Thanks in advance for your help!

[Stiltsoft support]

Hi @Nicole Uschman ,

As you've mentioned the Chart from Table macro that belongs to the Table Filter, Charts & Spreadsheets for Confluence app, you may use its Pivot Table or Table Transformer macros for data aggregation between the TableView macro and Chart from Table macro.

You may refer to our support portal directly (the portal is confidential), attach the screenshot of a table that you get after the TableView macro and we'll help you with the settings.

[Alex Medved _ConfiForms_]

Can probably use TableViewMerger instead and have something like this, using [count] - https://wiki.vertuna.com/spaces/CONFIFORMS/pages/22708367/TableViewMerger+macro+to+help+us+to+count+registrations+by+user