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
Charts : time graph
Migrateduser
<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
There are no comments yet