{
  "domains": [
    "icds-dashboard-qa",
    "reach-test",
    "icds-cas"
  ],
  "server_environment": [
    "softlayer",
    "icds"
  ],
  "report_id": "static-mpr_1_person_cases-optimized",
  "data_source_table": "static-person_cases_v2",
  "config": {
    "title": "MPR - 1 - Person cases (Static)",
    "description": "",
    "visible": false,
    "aggregation_columns": [
      "owner_id"
    ],
    "filters": [
      {
        "display": "Filter by AWW",
        "slug": "awc_id",
        "type": "dynamic_choice_list",
        "field": "awc_id",
        "choice_provider": {
          "type": "location"
        }
      },
      {
        "display": "Filter by Supervisor",
        "slug": "supervisor_id",
        "type": "dynamic_choice_list",
        "field": "supervisor_id",
        "choice_provider": {
          "type": "location"
        }
      },
      {
        "display": "Filter by Block",
        "slug": "block_id",
        "type": "dynamic_choice_list",
        "field": "block_id",
        "choice_provider": {
          "type": "location"
        }
      },
      {
        "display": "Filter by District",
        "slug": "district_id",
        "type": "dynamic_choice_list",
        "field": "district_id",
        "choice_provider": {
          "type": "location"
        }
      },
      {
        "display": "Filter by State",
        "slug": "state_id",
        "type": "dynamic_choice_list",
        "field": "state_id",
        "choice_provider": {
          "type": "location"
        }
      }
    ],
    "columns": [
      {
        "display": {
          "en": "Owner",
          "hin": "Owner"
        },
        "column_id": "owner_id",
        "type": "field",
        "field": "owner_id",
        "aggregation": "simple",
        "transform": {
          "type": "custom",
          "custom_type": "owner_display"
        }
      },
      {
        "display": "open_count",
        "column_id": "open_count",
        "type": "sum_when",
        "aggregation": "sum",
        "calculate_total": true,
        "whens": {
          "closed_on IS NULL": 1
        }
      }
    ],
    "sort_expression": [],
    "configured_charts": []
  }
}

Add optimized MPR 1 report
Add optimized MPR 1 report
