I have a simple table consisting of: UserName, Date, Hits
I'd like to produce a chart/table to look like this:
Bucket # Users
0 nnnnnn
1 nnnnnn
2-5 nnnnnn
6+ nnnnnn
Where the bucket represents the number of distinct days that a client has had at least one hit, and the #users represents the number of distinct clients within that bucket.
Any ideas on approach?
I can't do this in the laod script because the actual data model is more complex than the above, so the IntervalMatch function is not something I'm going to be able to use in this case.
I'm not sure what that means but I am fairly certain that the solution is nowhere near that simple, my columns are UserName, Date, Hits so which one of those does your column name of Col refer?
In the solution I'm assuming that the dimension needs to be a calculated dimension using Aggr statements along with IF....THEN....ELSE statements, and that the expression should be a distinct count of user name as long as the calculated dimension will support this.
