Report Filtering x amount of days

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

Report Filtering x amount of days

Postby 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

Re: Report Filtering x amount of days

Postby 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

Re: Report Filtering x amount of days

Postby 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

Re: Report Filtering x amount of days

Postby 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]

Who is online

Users browsing this forum: No registered users and 4 guests