This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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