0 Replies Latest reply on Oct 9, 2017 10:16 AM by jdw_uk

    Percent network availability pie chart

    jdw_uk

      Hi,

       

      I’d like to create a network summary report using the web-based report writer.

       

      On the front page I would like to have pie charts showing entire percent network availability for the past month, then below that availability per region (AMER/EMEA/APAC).

       

      Looking at the out-the-box reports there is one called “Availability of Entire Network - Last Month” – and I think I might be able to use that.

       

      The SQL used for that report is:

       

      SELECT  TOP 10000 AVG(ResponseTime.Availability) AS AVERAGE_of_Availability

      FROM

      ResponseTime

      WHERE

      ( DateTime BETWEEN 42977 AND 43006.9999884259 )

       

      Problem is that I am unable to use this to create a pie chart.

       

      I’m also not sure how the DateTime formula is working.

       

      Can anyone help?

       

      Thanks.