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!

WillT's avatar
WillT
Community Admin
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!