Counting records in each bin from total records and then apply filters

[kaustubh]

I have a column say  "col_1" and has category's A, B, C

I need to count the total number of records in each field from total records and see their proportion in bar chart and then apply some filters.

Ex: A/(A+B+C) and so on for B and C.

pLEASE hELP

[MindaugasBacius]

Simple in expression use:
A: Count({<col_1 = {'A'}>}) / Count(Total col_1)
B: Count({<col_1 = {'B'}>}) / Count(Total col_1)
C: Count({<col_1 = {'C'}>}) / Count(Total col_1)

You should come up with total of 100%.

[kaustubh]

Is it possible to perform in set analysis?

[kaustubh]

I have ample of bins to write code as you said. I am looking for something like aggregation where I can group every category from A to Z and count the records in each category and then divide by total. Something kinda one line code in set analysis.

I do not wish to write a code line by line for each category !

[kaustubh · Accepted solution]

Here is something I tried that worked for me using the "Total" function from your answer.

Count(Col_1)/Count(Total Col_1)

This generated a proper bar graph on dashboard for each bin proportion from whole adding to 100.

Thanks bro.