Report Generation

[Navanitha]

Hi,

I have a query that should be run from 00:00 till 23:59 everyday and a report should be generated for this as soon as the query runs. I tried scheduling a report for above requirement but I'm getting incorrect result. I scheduled it in following manner:

Schedule - run everyday
At - 00:00
Time Range - Last 1 day
Relative - earliest 1 day ago (No snap to, latest:now).

Can someone pls help me here. I have to run such queries and get the report for couple more projects.

[bandit · Accepted solution]

I believe these should be the correct time ranges.

earliest: -1d@d
latest: @d

I would recommend scheduling at least 5 min after the new day. This will allow for events which could be behind in indexing. You'll also want to ensure your time zone is correct for the account generating the report.

[Navanitha]

Thanks Rob..Its working