Probably not a good subject description.
I have a schema with user, date, and a action.
E.g.
Mike, 10-01-2010, A
Mike, 10-02-2010, B
Mike, 10-03-2010, C
Dan, 10-04-2010, A
Dan, 10-11-2010, C
What I want to do is using a range filter on date, identify a set of dates, and then find the last action for each user in that range, and then count the occurrences of them.
E.g.
between 10-01-2010 and 10-05-2010
Mike's was C,
Dan's was A
I want a count of 1 for A, and 1 for C.
If the range was the whole month, it would be 2 for C.
I can get this as a visualization, the bar chart in this case would show a value of "2", but because I am using a table calculation that is partitioned by user to get it. When I hover over the data I get "C, Mike, count of 1" and "C, Dan, count of 1", as opposed to "C, count of 2".
I hope this makes sense, I've been fiddling and I don't know how I can get to "C, count of 2" to be the datapoint. I am dealing with large numbers, so its not reasonable for me to have users infer the count from the visualization and not be able to hover over for exact numbers (or extract the data to Excel).
thanks,
Mike
posted a file.
