Multiple filters on joint data set

Following on from my previous post (<a class='bbc_url' href='http://www.birt-exchange.com/modules/vbulletin/showthread.php?t=10945'>http://www.birt-exchange.com/modules/vbulletin/showthread.php?t=10945</a>) I now have my joint data set giving me each opened task, which user it is assigned to (or unassigned) and the date by which it must be completed. 
 
taskID|userID|targetDate|userName 
 
I have a report parameter "reportDate", and would like to display a table as follows: 
 
User|Overdue tasks|tasks due on reportDate|tasks due a week after reportDate 
 
I'm assuming I need to use several filters here, based on the reportDate. Then I'll need to aggregate on userID. 
 
Any idea how this can be done, if it can, with BIRT?

Find more posts tagged with

Comments

cypherdj

I think I got it! Can't believe how simple it was as well, definitely kudos for BIRT there! 
 
Basically, I created a table, bound my joint data set and added a group userIDGroup on row["userID"]. 
Then in the table group header, I dropped 
1st cell 
- row["userName"], 
2nd cell (aggregation) 
- function: COUNT 
- filter condition: BirtComp.lessThan(row["targetDate"], params["reportDate"]) 
- aggregate on group: userIDGroup 
3rd cell (aggregation) 
- function: COUNT 
- BirtComp.equalTo(row["allOpenTaskByDepartment::TARGETDATE"], params["reportDate"]) 
- aggregate on group: userIDGroup 
4th cell (aggregation) 
- function: COUNT 
- BirtComp.between(row["allOpenTaskByDepartment::TARGETDATE"], params["reportDate"], DateTimeSpan.addDate(params["reportDate"], 0, 0, 7)) 
- aggregate on group: userIDGroup 
... 
 
This seems to perform well, now I'm trying to figure out how to produce a stacked bar chart based on the data in this table. So the series to be stacked are the aggregate per user, x axis would hold the dates (overdue, reportdate, reportdate+1week, ...). 
 
Any suggestions welcome!