Report on Count of Records closed where "Actual End Date" is before "Planned End Date"

[RC2]

Hi everyone. 

I need to build a dashboard with some sort of visual showing how many changes were completed ahead of schedule. So where the "Actual End Date" was before the "Planned End Date". End goal is to get a percentage or count per month. 

I can export the data to Excel and do a Pivot that way, but I would prefer NOT to do it manually every month and instead put a chart or data on a Dashboard in ServiceNow. But I can't quite figure out how to do it!!

Basically, I can't find a way to identify XXX records where the Actual End Date < Planned End Date. I'm not even sure if ServiceNow can do this...

[Victoria Cooke]

Use filter conditions in your report or your indicator and use the "is more than" (or is less than) x time and then choose your comparative date field. Even though the lowest time frame seems to be hours, Zero is a valid value and will find those records that are minutes ahead of their schedule.

www.mypepsico.com