Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
2 dimension calendar
trevezel
<p>hi there,</p>
<p>i m trying to design a 2 dimension calendar with Birt as following:</p>
<p>31 columns(day) and 12 rows(month)</p>
<p>each cell will be updated with daily events</p>
<p>can anyone help me ?
</p>
<p> </p>
Find more posts tagged with
Comments
Clement Wong
<p>There are at least three calendar DevShares examples you can use as a base:</p>
<p> </p>
<p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/files/file/443-birt-calendar-view-report/'>http://developer.actuate.com/community/forum/index.php?/files/file/443-birt-calendar-view-report/</a></p>
;
<p> </p>
<p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/files/file/1083-calendar-tabrptdesign/'>http://developer.actuate.com/community/forum/index.php?/files/file/1083-calendar-tabrptdesign/</a></p>
;
<p> </p>
<p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/files/file/1084-calendar-tab-2rptdesign/'>http://developer.actuate.com/community/forum/index.php?/files/file/1084-calendar-tab-2rptdesign/</a></p>
;
trevezel
<p>yes, i noticed these examples</p>
<p> but my layout is quite different.</p>
<p>i mean, i want a report grouped with months, then events filtered by the day when they occured</p>
<p>i have 3 columns in my Excel file :</p>
<p>month,day,event</p>
<p> </p>
<p>Year day1 2 3 4 5</p>
<p> </p>
<p>January</p>
<p> </p>
<p>February Event1</p>
<p> </p>
<p>March Event2</p>
Clement Wong
<p>Thanks for providing more details and clarifying.</p>
<p> </p>
<p>Here's a simple calendar report by month, day in the format you're looking for. It was created in the iHub 3.1 Designer, and runs in OS BIRT 4.5.0, using the sample Classic Models.</p>
<p> </p>
<p>It's one table with a grid of 32 columns. It's grouped by month (value in 1st column). Then the days are the rest of the 31 columns. Each day cell has a filter for the day number.</p>
<p> </p>
<p>There's a highlight rule on cell 30 (day 29), cell 31 (day 30), cell 32 (day 31) that checks for the month (and year if February for leap year) and turns the cell to white.</p>
<p> </p>
<p>
trevezel
<p>thanks Clement,</p>
<p>really good job !</p>
trevezel
<p>clement, one more question :<br>
events added to the calendar have a duration<br>
and a fixed number of lists(31) does not fit<br>
i woulds like to be able to manage a dynamic number of lists(linked to the number of events)<br>
for example :</p>
<p>excel file</p>
<p> </p>
<p>event name start of date end of date</p>
<p> </p>
<p>game 2016-12-24 2016-12-28</p>
<p> </p>
<p>i would like to have such a calendar :</p>
<p> </p>
<p> </p>
<p>month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31</p>
<p> </p>
<p>december | game |</p>
Clement Wong
<p>It looks like your requirements keep evolving, and the latest is like a Gantt chart, but reversed axis. Anything is possible with BIRT.</p>
<p> </p>
<p>What version of BIRT are you using? Open source, or commercial BIRT?</p>
<p> </p>
<p>Will you have events that cross over from one month to another like July 28 - Aug 2? Will you have multiple events that are in the same month that overlap days?</p>
<p> </p>
<p>Do you have a mock-up of the final output you would like your end user see?</p>
trevezel
<p>hi there,<br>
well i try to modify the report step by step as i am a newbie<br>
i use Birt 4.4.2, open source<br>
there is only one event a day but an event may take place on several months</p>
<p>my idea is to build a grid with a dynamic number of columns linked to the number of events/month</p>
<p>
the calendar view i try to get is in the attached file</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
trevezel
<p>well, in fact, yes, its similar to a Gantt chart</p>
<p>is anyway to get a Gantt chart template for Birt ?</p>
Clement Wong
<p>Gantt charts typically have time on the horizontal axis, and the activities and events on the vertical axis. BIRT already has a Gantt chart as one of the Chart Report Item options. Commercial BIRT also has Gantt, but can also add in Custom Visualizations so we're able to use other JavaScript visualization libraries such as d3.js, Google Charts/Maps, etc...</p>
<p> </p>
<p>For your specific requirement of a full year calendar view with the days on the horizontal axis, and month on the vertical axis, it is possible to modify the example I created previously so that it will color code each cell based on the event's category (via <em>Cell > Highlight</em>), and then add in the event for each day during the event's time span. There's other event notes in your example, but you can apply a similar logic to display those notes.</p>
trevezel
<p>hi Clement,</p>
<p>i really appreciate your help</p>
<p>still stuck to the same problem :</p>
<p>highlight is ok but the filter for the day number prevents other cells to be colored</p>
<p>in the same time, i dont know how to add the event for each day during the event's time span because of the filter.</p>
<p>thanks</p>
trevezel
<p>ok, after a long struggle, i think i ve just found the right filter :</p>
<p>BirtComp.between('day',BirtDateTime.day(row["ORDERDATE"]),BirtDateTime.day(row["Date de fin"]))</p>
trevezel
<p>now the last point is :</p>
<p>how to manage with the event name ?</p>
<p>it s repeated as many times as the event takes place</p>
<p>i would like to show the event name only once</p>
<p>i also tried to deal with the Gantt Chart, here is a first result as attached</p>
<p>the point is i would like to show bars one below the other(Y axis base on 30 days scale) as attached : Gantt as expected</p>
<p>i m afraid its not compatible with Gantt phylosophy ?</p>
<p>thanks for your help</p>
<p> </p>
Clement Wong
<p>The Gantt Chart that is provided with OS BIRT will not suit your specific needs.</p>
<p> </p>
<p>The various options are to use the DEAPI to create the grid dynamically, or to use the sample attached report (sample events up until 6/30) as a base and modify to show the event once, either in BIRT, or on the client side via jQuery.</p>
<p> </p>
<p> </p>
trevezel
<p>hi clement,</p>
<p>there is no data source for the dataset 'Joined Orders and Calendar Data Set'</p>
trevezel
<p>hi clement,</p>
<p>i m quite desesperate -(</p>
<p>trying to create a grid dynamically</p>
<p>but the number of columns is linked to the number of events to be dispatched</p>
<p>and then, i have to bind cells to data</p>
<p>i just need help cause BIRT API is really tough to deal with !</p>
Clement Wong
<blockquote class="ipsBlockquote" data-author="trevezel" data-cid="144069" data-time="1464618635">
<div>
<p>hi clement,</p>
<p>there is no data source for the dataset 'Joined Orders and Calendar Data Set'</p>
</div>
</blockquote>
<p> </p>
<p>It's a (left outer) Joined Data Set between the Orders (from the database) and the Calendar (scripted data set).</p>
trevezel
<p>well, i have an error when i run your design</p>
Clement Wong
<p>Sorry about the error. I created that example with commercial BIRT and used the commercial version of the Join Data Set, which is not available in OS BIRT.</p>
<p> </p>
<p>Attached is an OS BIRT (version 4.4.2) design of the same example I posted early.</p>
trevezel
<p>ok Clement,</p>
<p>that's better</p>
<p>indeed its really tough to show only the first event in the list all the more as i want that the color background remains</p>
<p>i can't use the feature 'Visibility' because the color is also hidden</p>
trevezel
<p>i ve just found a solution to hide events :</p>
<p>i apply the background color to the events i want to hide</p>
<p>now remains one last thing :</p>
<p>once some events are hidden, i would like to make the event name wider</p>
<p>if i increase font size, the event may be hidden by the cell next to it</p>
<p>i want to overlap the other cells if necessary</p>
trevezel
<p>maybe an idea would be to merge cells with the same value of event ?</p>
