KPI widget with percentage

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've tried following the instructions at https://www.zoho.com/analytics/help/dashboard/kpi-widgets.html#chart but nothing ends up being close. Can anyone give me a step-by-step walkthrough using the test data 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.

iddispatch_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