when no data by today's date, query the data by yesterday's date