|Relative time period & crostab filters [message #999486]
||Sat, 12 January 2013 03:18
| Paul STOFFAES
Registered: January 2013
The purpose of my post is to propose an enhancement regarding BIRT, to ensure that this is enhancement is really necessary and if it has not already been identified for the next BIRT release. |
This proposal comes from a difficulty i faced while i was building a report.
What i wanted to do in my report : display monthly the number of tickets resolved during last 12 months - Example: for 08/2012 to display the total number of demands resolved from 09/2011 to 08/2012.
To do so i used relative time period aggregation, and it worked perfectly....but...
I want to display 12 months in my crosstab, but to calculate my relative time period aggregation i need 24 months data ( example: if i want to display the period from 09/2012 to 10/2011 in my crosstab: to calculate the number of resolved demands during the last 12 months for the month of 10/2011, i will need data from 11/2011 to 10/2010)- See screen shot attached for better understanding of the obtained result.
Usually to limit the number of months in a crosstab, i use the filter property of my crosstab. As i need 24 months, i extended the filtered period to 24 months...but as a consequence, 24 months are displayed in my table...i found some ways to hide the columns (using scripts or highlights and the property display:none), but :
- display:none is not working into internet explorer
- my report needs to be exported properly in PDF and with this "workaround" the result is not good(see screen shot).
Sorry for this quite long explanation, hope this is clear enough - To partially solve my issue i obtained some workaround on Birt-Exchange (i cannot put the link because of my number of posts on this forum)
Those workarounds are quite complexe to put in place and are, from my point of view, not satisfying.
My "Enhancement" proposal: to create a "display filter" in addition to the already existing filter (filtering inputs data) of the crosstab. This "Display filter" could let the birt user have, for example, 2 years data into his crosstab, but only display 1 year data. From my point of view, this functionality became mandatory as soon as the Relative Time Period functionality was integrated into the crosstab object.
What do you think ? What is the procedure, can i create a demand into BUGZILLA ?
Thx in advance,