better indexes to improve lookup speed
properly filter reports with empty values