Filter by Day of the Week?

[wangtangkiki]

How can I filter my hands to only show hands from Mondays?
I want to see how many hands I've played on Mondays and my WR and such..

[WhiteRider]

You can do that with a custom filter on the My Reports tab.
Make a new report showing the info you're interested in and click the blue filters link to the left and add a filter like this:

dateextract_dow[datefix_fromutc[cash_hand_summary.date_played]]=0

0 is Sunday, 1 is Monday, etc.

[wangtangkiki]

Thank you very much. How would I add a filter to make it only show days where I played over 10,000 hands?
I tried this:

cnt_hands >= 9999

but it didn't work.

[kraada]

You'll want to add the stat Date Played - that will group your output by the individual date the hands were played on (the filter from WhiteRider will get you the right days of the week). Then add another filter: #Hands# >= 10000 and that will get you only days where you had 10000 or more hands.

[wangtangkiki]

Thank you :D
It worked perfectly.