{
    "reportPanel": "true",
    "reportTitle": "Report ",
     "defaultDateRange": "weekly",
    "dateRange": [
        "weekly",
        "monthly",
        "custom",
        "all"
    ],
    "dateField": "last_updated_on",
    "dataSource": {
        "queryFunction": "Cmshelper::getReportQuery",
        "orderBy": {
            "client_id": "ASC"
        },
        "groupBy": [
            "client_id"
        ]
    },
    "export": "true",
    "keyColumn": "id",
    "listColumns": [
        "vorganization",
        "ticket_count",
        "chat_count",
        "other_count",
        "reply_count",
        "resolution_time",
        "initial_responsetime",
        "resolved_in_first_response"
    ],
 "exportColumns": [
        "vorganization",
        "ticket_count",
        "chat_count",
        "other_count",
        "reply_count",
        "resolution_time",
        "initial_responsetime",
        "resolved_in_first_response"
    ],
    "detailColumns": [
        "vorganization",
        "ticket_count",
        "chat_count",
        "other_count",
        "reply_count",
        "resolution_time",
        "initial_responsetime",
        "resolved_in_first_response"
    ],
    "columns": {
        "vorganization": {
            "name": "Client",
            "type": "text",
            "sortable": "true",
            "searchable": "searchable"
        },
        "ticket_count": {
            "name": "Total Tickets",
            "type": "text"
        },
        "chat_count": {
            "name": "Total Chat ",
            "type": "text"
        },
        "other_count": {
            "name": "Total Others ",
            "type": "text"
        },
        "reply_count": {
            "name": "Average Replies Per Ticket ",
            "type": "text"
        },
        "resolution_time": {
            "name": "Average Ticket Resolution Time",
            "type": "text",
            "postfix": " minutes"
        },
        "initial_responsetime": {
            "name": "Average Initial Response Time",
            "type": "text",
            "postfix": " minutes"
        },
        "resolved_in_first_response": {
            "name": "Tickets Resolved In First Response",
            "type": "text"
        },
        "last_updated_on": {
            "name": "Updated On",
            "type": "datetime",
            "dbFormat": "datetime",
            "displayFormat": "m/d/Y H:i a",
            "sortable": "true"
        }
    }
}