[#5685] - Time Interval (15, 30, 60 mins) labels in report

Category:
Bug report
Priority:
High
Status:
Assigned
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

Hello,

Jasper Report Version: 4.5 with MongoDB Datasource.

This Report basically displays Sessions Utilizations for time intervals.

I am working on a tabular report which displays Totals and Percentages for each time interval group(15 min, 30 mins and 60 mins) for selected StartDate and EndDate.

Attached below the output of the session report.

Parameters:
StartDate(date/time)
EndDate (date/time)
TimeGroup (15,30,50)
-------------------
Out Put Fields:
<Session Date>
<Time Interval Groups>
<# of sesions>,
<% of successful sessions>
<% of unsuccessful sessions>
-----------------------------------------------

<Session Date> - (Grouped By session_create_datetime). Using Mongo document field session_create_datetime (mongo document field) tracks the session start time.

<Time Interval Groups> - Using session_create_datetime to get hour/mins intervals for each session and grouping in each time interval bucket. Used getHours(), getMinutes() Date functions for grouping.

Issue:

I have to display the Time Interval Lables for each time period group( 0-23 hour/mins/secs) for each day regardless sessions are exists or not in datasource. And I have to display the totals in appropriate label bucket. So that report users can just look at all the time intervals and get an idea of peak time of
sessions.

Thought of creating crosstab but did not how to List these Time Interval Lables in crosstab.

Sample Expected Output: For 60 mins interval

Example: Between Start Date and End Date: 2/12/2012 and 2/17/2012

Date: 2/12/2012

Time Group (60) Totals#1 Percentages#1 Percentages#2
2:00 AM – 1:00 AM
1:00 AM – 2:00 AM
2:00 AM – 3:00 AM 10 80% 20%
3:00 AM – 4:00 AM
4:00 AM – 5:00 AM
5:00 AM – 6:00 AM 50 75% 25%
6:00 AM – 7:00 AM
until
11:00 PM – 12:00 PM

Date: 2/13/2012

2:00 AM – 1:00 AM
1:00 AM – 2:00 AM
2:00 AM – 3:00 AM 5 50% 50%
3:00 AM – 4:00 AM
4:00 AM – 5:00 AM
5:00 AM – 6:00 AM 2 60% 40%
6:00 AM – 7:00 AM
until
11:00 PM – 12:00 PM

AttachmentSize
PDF icon Session Report.pdf30.55 KB
amannam's picture
Joined: Mar 15 2012 - 6:01am
Last seen: 10 years 2 months ago
Feedback
randomness