Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Data Cube : Change mesure condition of one dimension
Migrateduser
<p>Hi, </p><p> </p><p>Before posting this new topic, I've done a lot research on the forum BirtExchange and Eclipse Community Forum, but I haven't found a solution to my problem.</p><p> </p><p>I'm using Birt Designe to make reports based on the database of JIRA.</p><p> </p><p>I met a problem while I'm trying to make a cross table. </p><p> </p><p>The data set I gets is something like this: </p><p>Issue ID - Issue type - Open Date - Close Date</p><p>12131 - Incident - 01/03/2013 - 21/04/2013</p><p>12132 - Service Request - 23/03/2013 - 01/04/2013</p><p>12133 - Service Request - 01/02/2013 - 01/05/2013</p><p> </p><p>And I would like to make a cross table (Data Cube) like:</p><p>(Picture 2)</p><p> </p><p>Number of open and rest issues contains deux types of issue: </p><p>1. Issues which are opened in this week ( controled by the "Open Date") </p><p>2. Issues which are opened before this week and are closed after the start of the week (Controled by the "Close Date")</p><p> </p><p>The problem is that in the data cube I can't combine the 2 dimensions of date.</p><p> </p><p>Could someone give me a resolution? Maybe I should do some script? How? </p><p> </p><p>Thanks.</p><p> </p><p>Xi</p>
Find more posts tagged with
Comments
There are no comments yet