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

KMTek

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.

Ste Wright

Hi @KMTek 

Which reporting App are you using?

Ste