Forum Discussion
Missing data from the Office Activity logs
I run a query on a daily basis that uses the OfficeActivity table and filters the term Send within the operation field. I started to notice that my results were decreasing so I ran a summary for the...
RobYoung There could be a few things going on here. If you are not missing data then I would look at sampling data issues. For example, your time range is large. 30 days of processing will involve more data to process and can result in less accurate results. I suggest you reduce the "TimeGenerated" to 15 days and then set your aggregation to 7 days instead of 1. This will also reduce the whole number of data points, doing so take a greater load off the processing and can help with sampling accuracy.
Hope this helps
G.
This issue magically fixed itself shortly after posting. The sampling I usually due on a 24 hour bases, it was only for the purpose of the post above to show how it fluctuated from day to day. Thanks for the follow up though