Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
Moderator: Moderators
by eric1099 » Tue Jan 11, 2011 3:55 pm
It's easy to filter for current month or to put a date range manually each time I want to run a report.
But Is there a way to filter a report to always show the last 10 days, or 30 days etc. Something like "date > (today - 10 days)"?
-
eric1099
-
- Posts: 9
- Joined: Sat Jun 13, 2009 5:49 pm
by kraada » Tue Jan 11, 2011 3:59 pm
That's not possible at this point in time but I'll pass the request on to the development team for you.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by WhiteRider » Tue Jan 11, 2011 4:23 pm
You can do it in a custom report using a custom filter like this:
#Date Played# >= (current_date - interval '1 week')
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by eric1099 » Tue Jan 11, 2011 9:12 pm
It works Great, thanks!
I didn't seem to have a #Date Played# stat so I just added a new statistic using the (date_played) column.
Now I can easily run a report for the last 1 week or 30 days etc. Cool.
-
eric1099
-
- Posts: 9
- Joined: Sat Jun 13, 2009 5:49 pm
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 4 guests