how to create a performance analytics in servicenow to get the count of pending group approval in servicenow and i want to get the count based on days like pending approval greater than 5 days and greater than 10 days and greater than 15 days.
After getting the data i want to show that data in pivot table.
| Pending with Group | >5 days | >10 days | >15 days |
| Group A | 48 | 20 | 15 |
| Group B | 50 | 25 | 20 |
| Group C | 20 | 10 | 7 |
| Group D | 30 | 15 | 10 |
How can i achieve this ?
