Getting the percentage of rows that equal a certain string over all rows

[Cathal McConnell]

I have a column named 'Status', that has either 'Overdue' , 'Complete' or 'On Track' as it's values. I want to write a Dynamic Item expression in Text that finds the percentage of Overdue values on the entire rows.

ie. if count of rows = 100

and number of overdue = 25

the text should read 25%

 

Thanks in advance.

[Fabian Duerr]

One way to achieve this is to first create a calculated column to get the percentage for each string:

[Perc] =Count([status]) OVER ([status]) / Count([status])

And then get the percentage for "Overdue". So use this expression in your dynamic item:

First(If([status]="Overdue",[Perc]))

I also added this expression as a calculated column. But this is just to demonstrate to what it evaluates.