nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get a 'vote' count from the data in a table cell

Brad Johnson

I want to setup a product roadmap section where individual pages can be created, one per suggested change, and users can vote for a feature and a report lists the features sorted in descending order of votes so it shows from most popular to least popular.

I tried using Page Properties and Page Properties Report, including the 'Likes' metadata and the Likes appear great in the Page Properties Report but I can't sort on Likes. This would have been great as it doesn't involves Users editing a page in order to vote. The downside is without analytics we couldn't see who voted (which might be important).

I can add a Votes (Name) and Votes (Count) to the table on each page and tell users they have to add their name and increment the Count and then sort the report by Votes (Count) but that's a bit bleh.

I could just have the Votes (Name) in each table and maybe use Table Transformer to count the names (using SQL and/or regex) and add a new column as part of the report but that's beyond my capabilities. I would prefer the name to be a @mention but also OK if they have to type it in as text if there is a solution here.

I would love to hear any ideas on how to achieve this expanding either on my ideas above or any new idea.

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Brad Johnson ,

If you need help with the Table Transformer macro (or maybe the Pivot Table macro will suit you), you may give us a manually created table with dummy data that looks like the Page Properties Report macro that you will get for the real use case. Then you may provide us with the desired output (to count distinct names, votes, etc.) and how you want it to look like (again with the help of a manually created table).

We can work here or via our support portal that is confidential (we can use real screenshots there).

But again if we are talking about usernames, features and voting, maybe it is not very convenient to use manual work? Type in names, increment the numbers, etc.

Maybe it's easier to use apps for voting - we also provide one for Confluence Cloud and it's free. Please check the Pollmaker for Confluence.

With its help you'll be able to create single and multi vote questions and decide what kind of polls you need: anonymous or "clear" where you will see the voters' avatars.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Brad Johnson ,

We can work here or via our support portal that is confidential (we can use real screenshots there).

But again if we are talking about usernames, features and voting, maybe it is not very convenient to use manual work? Type in names, increment the numbers, etc.

Maybe it's easier to use apps for voting - we also provide one for Confluence Cloud and it's free. Please check the Pollmaker for Confluence.

With its help you'll be able to create single and multi vote questions and decide what kind of polls you need: anonymous or "clear" where you will see the voters' avatars.

Brad Johnson

Hi Katerina,

i had looked at Pollmaker but I really want to setup a template for users to create pages and capture the description and requires menus for the feature and have people vote directly on that page rather than manually re-enter feature titles into poll maker.

I’ll post some detail of what I’d like tomorrow.

Katerina Kovriga {Stiltsoft}

If you have the examples of real source tables with data for the Page Properties Report macro (with headers that we'll be able to use inside the SQL query), raise a support ticket - attach the screenshots for our agents to recreate similar tables and guide you through the process.

If you prefer manually created tables with dummy data, you may update this thread.

Brad Johnson

Here is an example of a table on the feature page

I have typed names as text here for privacy while posting this. I would prefer people @ mention themselves but would accept either really as I don't expect people to misspell their own name..

Here is what the report could look like. Its simply a page properties report of the features sorted by most popular (The row order should be reversed in the below). A solution could be that the report view would show a column of the count of the names in the 'Vote (Names) field and it would be sorted by that. If we can't count @mentions then we might need to enforce a format, like a separator (e.g. comma) or tell people to always put first and last name so we know 2 words is one vote.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud