Hi I am attempting to build a widget that shows percentage orders completed on time. I’m having a tough time shaping the data. A simple table below - I’d like to show OnTime as a percent of “yes” values. Ideally I’d like to use the meter KPI, in below example it would read 75% for the month. Any suggestions?
Date | Order# | OnTime |
2021-10 | 1200 | Yes |
2021-10 | 1201 | Yes |
2021-10 | 1202 | Yes |
2021-10 | 1203 | No |
Best answer by lauraj46
View original