Segment Calculator and Possible New Filter

[Da80th]

hi Stan,

Can you create a summary stats table for Segment Calculator? if you sort each column with most tickets to lowest ticket and give ranking #1 for segment with most tickets... see what I mean below:

03/28/08 3-0-2,4-0-1,2-0-3,2-0-3,3-0-2,3-0-2,3-0-2,3-0-2,3-0-2,2-0-3,1-0-4
03/29/08 1-0-4,3-0-2,1-0-4,3-0-2,3-0-2,3-0-2,1-0-4,1-0-4,3-0-2,1-0-4,1-0-4
03/30/08 2-0-3,0-0-5,2-0-3,2-0-3,0-0-5,2-0-3,1-0-4,2-0-3,2-0-3,1-0-4,2-0-3
03/31/08 3-0-2,4-0-1,4-0-1,2-0-3,3-0-2,1-0-4,1-0-4,3-0-2,3-0-2,2-0-3,3-0-2
04/01/08 3-0-2,2-0-3,2-0-3,1-0-4,2-0-3,3-0-2,1-0-4,2-0-3,0-0-5,2-0-3,0-0-5

Here's what the latest 5 draws would look like base on the above segments:

03/28/08 2 4 1 1 3 3 3 2 1 1 3
03/29/08 2 2 2 2 4 1 2 3 1 3 3
03/30/08 1 5 1 1 3 1 2 1 1 3 1
03/31/08 2 4 4 1 3 1 3 2 2 2 2
04/01/08 2 1 1 3 1 3 3 1 5 2 5

For example, 4/1/08 with Column 0 = 3-0-2, if you sorted Column 0

2-0-3 209440
3-0-2 157080
1-0-4 124355
4-0-1 52360

then you get 2 for Column 0


A filter a be create similar to Segment Combinations.


Thanks,


Da80th

[stan]

[quote=Da80th]
Can you create a summary stats table for Segment Calculator? if you sort each column with most tickets to lowest ticket and give ranking #1 for segment with most tickets... see what I mean below:
[/quote]

sorry, i don't understand i'm afraid ...