Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Charts : time graph
shir
<p>Hi All,</p>
<p> </p>
<p>I am trying to design a simple report which displays details of the input time of files which we receive from other servers.</p>
<p> </p>
<p>This report will have a simple time graph;</p>
<p>x-axis: Calender date </p>
<p>y-axis : time at which the file is received.</p>
<p> </p>
<p>for example:</p>
<p> </p>
<p>CalenderDate::FileInputDateTime</p>
<p>15-Oct-2014 15-Oct-2014 11:00 </p>
<p>16-Oct-2014 16-Oct-2014 08:00 </p>
<p>17-Oct-2014 17-Oct-2014 11:30 </p>
<p>18-Oct-2014 18-Oct-2014 09:20 </p>
<p>19-Oct-2014 19-Oct-2014 09:45 </p>
<p> </p>
<p>When i plot the graph with the same data, the graph always has a +ve gradient, since it considers both date and time. i.e. <span style="font-size:14px;">15-Oct-2014 11:00 < </span><span style="font-size:14px;">16-Oct-2014 08:00 </span></p>
<p>(but 11:00 should be greater than 08:00, considering only time and not date)</p>
<p> </p>
<p>However when i remove the date from date-time column, the data is taken as a text and dose't plot the graph.</p>
<p> </p>
<p>Can anybody suggest as to how we can achieve this?</p>
<p> </p>
<p>Please let me know if you need any further details from my side</p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
micajblock
<p>Use a function (dateDiff) to get the minutes of the day and plot that.</p>
shir
<p>Thanks,</p>
<p> </p>
<p>However this function will return an integer value(minutes of the day).</p>
<p> </p>
<p>I would like to get the y-axis scale as time, hh:mm (00:00 to 24:00), and plot it against the processing date(x-axis)</p>
micajblock
<p>What version of BIRT are you using?</p>
shir
<p>Hi, </p>
<p>I am using BIRT RCP, 4.3.1</p>
micajblock
<p>Thanks, I will try to find some time to build an example.</p>
shir
<p>bumping the post!</p>
micajblock
<p>A little tricky but here is a solution. Let me know if this works for you.</p>