We are attempting to convert a report into an indicator we can put in the Analytics Hub for Management. When running the indicator, and comparing to the report results, on most data-points, they match. However, there are some data-points (days) that they don't match. For those days, we downloaded the results from the Data Collector job into Excel. When we sum up the hours (we're dealing in hours), it is a different number than the number showing in the Analytics Hub for that day. Why wouldn't it show the right number?
Example...
When we export the records in Analytics hub to Excel, the hour total is 2208 (which is correct)
But the Analytics Hub shows the number for this data as 2166 (which is incorrect).
Why would it show 2166 if the records it's pulling total 2208?
