How to troubleshoot Alert showing NO DATA
Start by using the Query Inspector to see why the query it is returning no data.