Calculate % of occurrence with delays > 10 days

[davdiste]

Hello,

I'm trying to define an expression for calculate the % of occurrence with delays > of 10 days.

A example of the dataset is enclosed below.

date	delay_days
01/10/2016	2
02/10/2016	3
03/10/2016	4
04/10/2016	15
05/10/2016	20
06/10/2016	2
07/10/2016	15
08/10/2016	9
09/10/2016	76
10/10/2016	43

The desired value of the indicator is 50%

In your opinion what is the best way to define the expression?

Thanks

Davide

[Anonymous]

try this in straight table :

count({<[delay_days]={">10"}>}delay_days) / count(TOTAL delay_days)

and change the Number format  to "show in Percent"

[sunny_talwar · Accepted solution]

If this is done in a text box object, I don't think denominator needs a total here:

Count({<[delay_days]={">10"}>} delay_days)/Count(delay_days)

[davdiste]

thanks, both solutions work fine!