0 Replies Latest reply: Aug 3, 2007 7:59 PM by 3004 RSS

    Need help creating a reports - example below

    3004
      <p>I have server data showing outages as event occurs.</p><p>I need to prepare a report showing total outage durations thathappened within 24 hours period.</p><p>sample data and expected calculated data for report is asbelow:</p><p>I need to build logic for last column - Calculated Downtime inlast 24 hours.</p><p>Any help is appreciated.</p><p>Thanks</p><p> </p><table><tr style=" height: 63.75pt;" height="85"><td width="92" class="xl23" style=" width: 69pt; height: 63.75pt;"height="85">System Id</td><td width="134" class="xl23" style=" width: 101pt;">Start Time</td><td width="84" class="xl23" style=" width: 63pt;">Downtime inminutes</td><td width="64" class="xl23" style=" width: 48pt;">CalculatedDowntime in last 24 hours</td></tr><tr style=" height: 12.75pt;" height="17"><td style=" height: 12.75pt;" height="17">A.com</td><td class="xl22" x:num="39182.802083333336" align="right">4/10/200719:15</td><td x:num="" align="right">11</td><td x:num="" align="right">11</td></tr><tr style=" height: 12.75pt;" height="17"><td style=" height: 12.75pt;" height="17">A.com</td><td class="xl22" x:num="39183.680555555555" align="right">4/11/200716:20</td><td x:num="" align="right">7</td><td x:num="" align="right">18</td></tr><tr style=" height: 12.75pt;" height="17"><td style=" height: 12.75pt;" height="17">A.com</td><td class="xl22" x:num="39188.427083333336" align="right">4/16/200710:15</td><td x:num="" align="right">5</td><td x:num="" align="right">5</td></tr><tr style=" height: 12.75pt;" height="17"><td style=" height: 12.75pt;" height="17">A.com</td><td class="xl22" x:num="39188.659722222219" align="right">4/16/200715:50</td><td x:num="" align="right">4</td><td x:num="" align="right">9</td></tr><tr style=" height: 12.75pt;" height="17"><td style=" height: 12.75pt;" height="17">A.com</td><td class="xl22" x:num="39188.6875" align="right">4/16/200716:30</td><td x:num="" align="right">4</td><td x:num="" align="right">13</td></tr><tr style=" height: 12.75pt;" height="17"><td style=" height: 12.75pt;" height="17">A.com</td><td class="xl22" x:num="39189.121527777781" align="right">4/17/20072:55</td><td x:num="" align="right">6</td><td x:num="" align="right">19</td></tr><tr style=" height: 12.75pt;" height="17"><td style=" height: 12.75pt;" height="17">A.com</td><td class="xl22" x:num="39191.753472222219" align="right">4/19/200718:05</td><td x:num="" align="right">4</td><td x:num="" align="right">4</td></tr></table>