Thanks Stephen - as menitioned in the original question, I can't do a daily count summary like this because the value has to be unique across 30 days, not unique per day. For example, value "abc" can appear on both day 1, 2, and 3, if we use dedup over the past 30 days, 'abc' will be only counted once. However, if we dedup on a daily basis, 'abc' will be counted in the summary index for day 1, day 2 and day 3, and when we add up the total unique value count over the past 30 days, 'abc' will be counted 3 times.
... View more