Note that you can't expect the data you retrieve from the DES to match up with the Community Manager Reports or other analytics platforms (like Google Analytics or SiteCatalyst) because the methods and time spans for the data collection are different. As just one factor, the DES uses Greenwich Mean Time for its timezone (non-editable), and the CMRs use whatever timezone your community uses (or a rolling span). When you use data from the DES, make sure you only trend it against data from the DES so you can appropriately compare apples to apples.
Is this reason also why the date and day is incorrect as displayed in the Activities date range? In my time zone (Pacific Time), today is Monday. But if I convert to GMT, today is supposed to be Monday also. Does the date picker in the API has bug? Or am I not understanding it right?
Another question, what is retention period for activity logs in JDES? Ryan Rutan maybe you can help out here. Thanks.