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

[Ultron]

Hi,

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   |

Thanks.

[Stephen Wright _Elabor8_ · Accepted solution]

Hi @Ultron 

Which reporting App are you using?

Ste

[Ultron]

Hi @Stephen Wright _Elabor8_ ,

ServiceRocket Reporting plug-in.

Thank you

[Ultron]

Version 6.16.2 Server. Our Confluence is 7.13.2

[Stephen Wright _Elabor8_]

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 - https://marketplace.atlassian.com/apps/186/reporting-for-confluence?hosting=server&tab=support
3. Choose a contact option from the right-hand menu

Let us know if you find a resolution!

Ste

[Katerina Kovriga _Stiltsoft_]

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.