Calculating a computed column with percentages

Can someone explain how to create a computed column in a report table/dataset that calculates the percentages of values in another column? For example, if an existing column contains the number of different kinds of illegal activities seen, I want a column that shows the relative percentages of each of these (25% were snares, 35% were timber cutting, etc.)

Thanks!

Hi rbergl

You can use PERCENTSUM as aggregation on computed column

Here the result

Regard

Lili Sadikin

2 Likes