1 of 1 people found this helpful
Pooja Sarnaik, please add new questions that you have as new threads. I've branched your question form the last thread into a new one for you.
The simple answer is: Run your VizAlert on the hour (:00) every hour, and set a relative date criteria for the alert to look at Previous Hour. This will run very soon right after the current hour starts, and limit the emails that are sent to only those database records added in the previous hour, ignoring anything that came before.
This is a good technique because even if your alert runs late--say at ten minutes past the hour--you are still looking at the same window of time. In fact, if you aren't 100% sure that the data will make it into your database when the events actually occur (say that a record actually that says it was created at 4:15 actually becomes available in the database at 5:01), you can simply adjust your hourly schedule to run later in the hour to give it some buffer time. So if you knew that records would become available no later than 30 minutes after their created time reflected, you could set the hourly VizAlert to run on the :30 mark of every hour. Then, the record that said it was created at 4:15 but actually becomes available at 5:01 would still be picked up by the alert when it runs at 5:30.
The relative date filter can be applied as a filter in your viz (with the disadvantage of hiding other contextual marks that might be helpful to see for troubleshooting), or as a criteria in your Email Action trigger.