How to work out the percentage of a column

[symun23]

Hello,

So I am trying to work out the percentage of different values in a column.

This is the table and I want to know what percentage are 'S1', whenever I have tried to calculate this I get an error message about using a string.

ID	TYPE	MECH
NDPD0424834	NSS	NS
NDPD0790352	S1	S1
NDPD0829788	S1	S1
NDPD0830944	S1	S1
NDPD1061480	S1	S1
NDPD1658980	S1	S1
NDPD1659576	NSS	S1
NDPD1659692	S1	S1

So in excel I would do something like this =COUNTIF([TYPE],"S1")/COUNTA[ID]*100

The bit I am struggling on is not being able to just focus on the rows with "S1"

[quentin_vigne]

Hello @symun23

Add a multiple row card on your report

Add you column TYPE on it

then add a new column : 

percentage = COUNTROWS(YOURTABLE)/CALCULATE(COUNTROWS(YOURTABLE);ALL(YOURTABLE))

(replace YOURTABLE by your table name)

Then add the column percentage to the multiple row card

If you don't understand, give me your table name and I'll do it for you

[symun23]

Thanks for the reply Quentin,

The table name is COMPLETE_UPGRADE

[quentin_vigne · Accepted solution]

Here is what you need to do : 

1 - Add new column with this formula : 

percentage = COUNTROWS(COMPLETE_UPGRADE)/CALCULATE(COUNTROWS(COMPLETE_UPGRADE);ALL(COMPLETE_UPGRADE))

2 - Add a multiple row card

3 - Add TYPE

4- Add percentage column (You can choose to display it either as a number either as a percentage. On my screenshot I've choosed the percentage of S1)

Et voilà !