If we have a look at the "Monitor, Internal Users" we can change the time range from "day" to "week" to "month".
If we want to export the same displayed time range as CSV for Excel, we don't get the same period... :oops:
Choosing the "day" for displaying in the browser (24 Aug 2008 16:00 to 25 Aug 2008 16:45 (GMT +0200) Data in time range: 100.0 % complete), we get the URL:
and the CSV-data looks like this:
Begin Timestamp,End Timestamp,Begin Date,End Date,Internal User,Clean MessagesYou can see, this is just an HOUR and not a DAY.
1219586400.0,1219589999.0,2008-08-24 14:00 GMT,2008-08-24 14:59 GMT,[email protected],1
The same for the time-range "month":
Begin Timestamp,End Timestamp,Begin Date,End Date,Internal User,Clean MessagesThis is just a DAY not a month...
1217023200.0,1217109599.0,2008-07-25 22:00 GMT,2008-07-26 21:59 GMT,[email protected],5
How can I export the same time-range to Excel as shown in the Browser with the same values for incoming/outgoing number of mails?