Hello,
In our pre-SN setup, we have a tool that shows a table like so:
| Engineer | Total Number of Tasks | Tasks Overdue for status update | Combined overdue time* |
|---|
| | | |
| | | |
| | | |
| | | |
)*for example, if you have one task overdue by a couple of days, and another overdue by a week, you would have a combined time of 9 days)
So at the moment, I haven't tried to figure out the combined overdue time part yet, but I'm trying to make a basic report that shows the first three columns.
I'm using a Multilevel pivot for this, but right now, it doesn't seem to allow me to show differing counts. I can only show the number of tasks overdue, but not another column that shows the number of tasks total (both due and overdue).
Is it possible to do this in a report? A Pivot table seemed like the right way to go, or is there another ServiceNow widget, or application (or heck, even code up an application) that I need to use for my use case?
