0 Replies Latest reply on Oct 15, 2009 4:04 AM by jba

    Current and Average responce time -> Group per location

      Hi,

       

      I'am trying to get a view of Current and Average responce time grouped by location.

       

      I got a Custom property with a location (country) ID in it.

      Have problem with creating a view->report thats getting the Avg. respons time for every node in that location.

      My view should look like this

      Location (taken from custom property) , Current Avg. Responce time (for that Location, taken from current node responce time) , Current Avg. Responce time (for that Location, taken from Avg. node responce time)

       

      I know that you can create a report from a sql statement, but my sql knowledge is limited :)

       

      Hope someone can help me out.

       

      Best Regard

      Jack Bachmann

      ALK-Abello