As evidence, I've attached snapshots of 3 reports, all with differing output. I queried SA for a particular report, and the results are as follows.
1. 4 days = 131 results
2. 96 hours (4 days) = 130 results
3. 4 months = 3 results
Why this fluctuation and inconsistency? I'm unable to make sense of it. There are many more examples. For instance, 7 days = 96 results, and 168 (7 days) hours = 117 results. Why? and how come the more I increase the time range, the fewer the results?
I hope I'm not missing something here, 'coz logically the output fluctuation (lack or increase of) makes no sense to me. Eric Partington
Hi Visham,
Check the time range of the actual report results. The different reports are not overlapping time ranges as you're probably expecting. Past 4 months is the past 4 whole months, so beginning of April to end of July. Past 4 days is midnight 4 days ago to midnight last night. etc.
You need to check 'Use relative time calculation' so that they all end at the time the report is run and past X is from that point instead of the last whole hour, last whole day, or last whole month.
Thanks,
Guy