KPI widget with percentage
I'm trying to create a KPM widget that displays current performance as a percentage - something like the picture below.
I'm trying to display the percentage of records where dispatch_time is below the target of 300 seconds. The dispatch_KPM is not a required field - this is a formula-generated boolean true/false field that I've included in case it makes it easier to generate the widget.
| id | dispatch_time | dispatch_KPM |
1 | 235 | true |
2 | 305 | false |
3 | 500 | false |
4 | 30 | true |
5 | 70 | true |
6 | 650 | false |
7 | 270 | true |
8 | 220 | true |
9 | 370 | false |