using opened_on as date for filtering all indicators with report date range