Brian,
Thanks for your help, I am sure it is frustrating to want to help, but don't have enough info.
I appreciate your efforts.
My (hopefully) last comment here. Sorry if I ramble a bit..
I have mine working just as you, with a major exception, and I will explain why (sorry:)).
If i use the Watched Percent Rule, not only do I have my first up audience, series, season, and episodes jumbled a bit, there is one more con not mentioned, but I bet it happens to many of us that use that rule. You sit down with sig. other to watch your next episodes, and you open the series you want, and it presents you with the next episode. But, you mention (or they do), "is THAT the next one?" What happened to X? Where is Y? Are you sure MC didn't skip one? So once in a while I need to go to a view that shows all and determine if MC made a mistake. A classic is accidentally stopping moments before the end of the show, MC marks it watched but you weren't done. You go to start watching another time and think... "I didn't think we finished the last one", you go check and yes it is 91 %, or whatever. Sure you can adjust that percent higher, but it works well most the time. Another pro for seeing the past ones is the question of what happened last time? If you want to read the plot of the last one you need to go to another view and find it.
So what do I do? If i use your suggestion of a rule that limits the last played to 7 days, then it negates the smartlist rule for three weeks, and, for me, removes all UN watched shows
.
My clumsy calculation works pretty nice. I suggest you might try it, best of both worlds I think. I convert both NOW and LAST PLAYED to MC Time, and subtract LAST PLAYED from NOW, and then make that a new field (I called it "LAST PLAYED DAYS"). Then use the (again clumsy) rule LAST PLAYED DAYS
is "Empty; 0; 1; 2; 3; 4; 5; 6; 7"
So it gets all unwatched shows (Empty, or 0), and any watched shows in the last 7 days (or so). Depending on how many episodes you consume over x time, you can adjust it so it shows just a few of the past for reference. And it keeps the sort all the way down from who gets to watch next to the proper ep order. We think it works well.
I hope that helps someone... I want to share too...
Thanks again
Don