|
Re: Filtering crosstab data by dates [message #882140 is a reply to message #882087] |
Tue, 05 June 2012 23:21 |
|
Have you tried using a filter on the crosstab that make use of:
BirtDateTime.addWeek()
Use your date field as the expression and then use a between operator
and then the first value should be :
BirtDateTime.addWeek(new Date, -12) and the second value should be
new Date
Jason
On 6/5/2012 4:29 PM, Shayne Paddock wrote:
> I have a dataset that returns values for the past year. I create a last
> 12 month crosstab based on that.
>
> I also want to show the last 12 weeks of values as well using the same
> dataset as above. I've set up my dimensions to be year and week of year.
> How do I only return the last 12 weeks of data for that particular
> crosstab?
>
> I'm running BIRT 3.7.1
>
> Kindest regards,
> Shayne
>
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.12142 seconds