REPORT_DIMENSIONS = {
    "district": ("agri_district","district_name"),
    "state": ("agri_state","state_name"),
    "crop": ("crop_name","name"),
    "farmer": ("agri_users","userName")
}

REPORT_METRICS = {
    "total_land": {
        "table":"agri_land_user_rels",
        "column":"land_size",
        "aggregation":"SUM"
    },

    "farmer_count": {
        "table":"agri_users",
        "column":"id",
        "aggregation":"COUNT"
    }
}