Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
try this in straight table :
count({<[delay_days]={">10"}>}delay_days) / count(TOTAL delay_days)
and change the Number format to "show in Percent"
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)
thanks, both solutions work fine!