Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Reporting plug-in - Select distinct values in a column (and count)


Does someone know if it is possible to do a kind of SELECT DISTINCT over the values of a column with the Reporting plug-in?

And the cherry on the top of the cake, not only show the values distinctively but also showing an extra column with the count of values.

For instance, taking the following list of values in a single column table:

A, B, C, B, C

The resulting table would show:

| Value | Freq |

|    A    |    1   |

|    B    |    2   |

|    C    |    2   |



2 answers

1 accepted

0 votes
Answer accepted

Hi @Ultron 

Which reporting App are you using?


Hi @Stephen Wright _Elabor8_ ,

ServiceRocket Reporting plug-in.

Thank you

Version 6.16.2 Server. Our Confluence is 7.13.2

Hi @Ultron 

Not so sure for that reporting app - but have you tried contacting the vendor for more direct assistance?

You can do this from the Marketplace...

  1. Go to the App's listing
  2. Select the Support tab -
  3. Choose a contact option from the right-hand menu

Let us know if you find a resolution!


Like Ultron likes this

Hi @Ultron ,

We can also suggest trying our Table Filter and Charts for Confluence app and its Pivot Table macro - seems that this macro will be able to fulfill the case. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

344 views 2 9
Read article

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