I have a table along the lines of: timestamp, user_id, ... with hundreds of thousands of records per day, and tens of thousands of distinct users. I can get report of Count(user_id) daily without issues. However, when I switch aggregation to DistinctCount, the report is incomplete and only shows a couple days. When I look at the generated query, I see that it's trying to bring in all distinct user_id records, instead of sending COUNT (DISTINCT user_id) to the database. Because the record limit is 200,000, the report can only get data for a few days. If it did COUNT DISTINCT, it would of course be just a single number per day. Thank you, Dmitry
