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.