Don't include NULL column values in the statistics

We were already excluding graphs where all the data was NULL
but it's possible by directly manipulating the database to
have some values NULL and some non-NULL, so exclude any NULL
values anyway.

1 files changed, 1 insertions, 1 deletions

diff --git a/app/models/public_body.rb b/app/models/public_body.rb
index 436418fe5..300fdb956 100644
--- a/app/models/public_body.rb
+++ b/app/models/public_body.rb
@@ -658,7 +658,7 @@ class PublicBody < ActiveRecord::Base
         ordering = "y_value"
         ordering += " DESC" if highest
         y_value_column = "(cast(#{column} as float) / #{total_column})"
-        where_clause = "#{total_column} >= #{minimum_requests}"
+        where_clause = "#{total_column} >= #{minimum_requests} AND #{column} IS NOT NULL"
         public_bodies = PublicBody.select("*, #{y_value_column} AS y_value").order(ordering).where(where_clause).limit(n)
         public_bodies.reverse! if highest
         y_values = public_bodies.map { |pb| pb.y_value.to_f }