I want a distinct count for a given field by day, but this count also needs to look at all previous days in the given time range to see the remaining distinct count? For example: When I search for all events that are on Monday the result is : a,b,c,d,c,z When I search for all events that are on Tuesday the result is : a,b,c,d,e,f,a,b When I search for all events that are on Wednesday the result is : a,b,c,d,e,f,z The distinct count for Monday is 5 and for Tuesday is 6 and for Wednesday it is 7. The remaining distinct count for Tuesday would be 2, since a,b,c,d have all already appeared on Monday and the remaining distinct count for Wednesday would be 0 since all values have appeared on both Monday and Tuesday already. How would I be able to do this? Thanks
... View more