Forum Discussion

RehanSaeed's avatar
RehanSaeed
Frequent Visitor
10 years ago
Solved

Incorrect Average in Map Control

I work for Bridge International Academies which has 100,000 students and 6,000 schools in Kenya, Uganda and Nigeria. I am trying to visualize the average assessment scores in each school using the ma...
General Comment
  • WillT's avatar
    WillT
    10 years ago

    Hi Rehan. I think you got in touch over email and we sorted this out.

     

    For anyone else who finds this - he'd created a visual using a [Score] field, and was filtering on that field for [Score] >=0. The default filter that was created is a measure filter, which applies to the aggregated values in the visual. He wanted to filter the underlying rows, so creating another filter that was an attribute filter helped get the results he expected.

     

    Hope that helps anyone else with a similar problem!

ashishrj's avatar
ashishrj
Power Participant
10 years ago

RehanSaeed Altogether plotting data for such a large number of students will provide nonsensical result for sure. Try creating proper measure for average scores in your data model and more importantly try using filters to restrict data for particular region so that less data points are shown and map becomes more visualizable. Hope this helps :smileyhappy: