Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 08 Dec 2015 at 9:48am
As long as you sent your date filters correctly, yes the report would continue to grow as more data is available. So I would assume in the select expert formula. It would look something like this.
{Date field} >= {?Date Parameter} and {Date field} <= currentdate()
thank you for the response. I've been tied up with other things so just getting back to this. Is there a way to show week totals for each 7 day time period without using parameter data for each week? by just using a beginning date? say if someone used a beginning date of 7/5/2015
i would want to show on separate lines, activity between 7/5 and 7/11,
then activity between 7/12 and 7/18, etc. right up until either today's date (or another parameter set as an ending date)
Is there a way to add to the starting date+6 days, and then that date+6 days etc...if that makes any sense ?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 14 Dec 2015 at 5:03am
I think (if I understand correctly) the answer should be yes. One trick you can use is group by the date (you have options on how long the time period is for the the group).
You can do a lot of math on date fields (as simple as just adding or subtracting a number). There is the dateadd function. There are a number of options you can do with the dateadd function.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum