Repeated Complaints
📄 Complainants PDF 📄 Same-Issue PDF 📄 Recurrence PDF🔁 Repeat Complainants (8 callers with 3+ complaints)
CSVSame mobile number raising 3+ complaints, with their address and the nature of complaints raised. High counts on a single street usually mean an unresolved recurring problem.
| Mobile | Count | Name(s) | Address (Street) | Depot | Nature of Complaint |
|---|---|---|---|---|---|
| 9840042515 | 7 | BEGAM / S BEGAN | Unnamalai Amman Street | 113 | No Water Supply, Sewer Main Block |
| 9940239468 | 7 | JAYANTHI | Unnamalai Amman Street | 113 | No Water Supply |
| 9025880393 | 4 | premanand | Unnamalai Amman Street | 113 | Sewer Main Block |
| 9600015136 | 4 | K VENUGOPAL / K VENUGOPALAN | Unnamalai Amman Street | 113 | No Water Supply |
| 9600049099 | 3 | Ramaswamy | Unnamalai Amman Street | 113 | No Water Supply, Sewer Main Block |
| 9789220146 | 3 | DEEPTHA VENKATESAN, NAVEEN VIJAYARAGHAVAN | Unnamalai Amman Street | 113 | No Water Supply, Sewer Main Block, Water Short Supply |
| 9840871590 | 3 | Saraswathi | Unnamalai Amman Street | 113 | Sewer Main Block |
| 9940664379 | 3 | magesh / Mahesh | Unnamalai Amman Street | 113 | No Water Supply |
📍 Same Issue · Same Street (2 chronic combinations, 5+ repeats)
CSVStreet + category combinations occurring 5+ times — chronic chokepoints where tickets keep getting closed but the cause isn't fixed.
| Count | Category | Street | Depot |
|---|---|---|---|
| 27 | No Water Supply | Unnamalai Amman Street | 113 |
| 19 | Sewer Main Block | Unnamalai Amman Street | 113 |
⏱ Recurrence — Same Issue · Same Street
PDFHow fast the same category recurs on a street. Avg gap = mean days between consecutive complaints; higher per-month = faster-recurring, unresolved.
| Category | Street | Depot | × | Avg gap | /mo |
|---|---|---|---|---|---|
| No Water Supply | Unnamalai Amman Street | 113 | 27 | 20.4d | 1.53 |
| Sewer Main Block | Unnamalai Amman Street | 113 | 19 | 20.1d | 1.58 |
⏱ Recurrence — Repeat Complainants
PDFHow often the same caller comes back. Avg gap = mean days between that caller’s complaints.
| Mobile | Name | Depot | × | Avg gap | /mo |
|---|---|---|---|---|---|
| 9840042515 | BEGAM / S BEGAN | 113 | 7 | 60.3d | 0.58 |
| 9940239468 | JAYANTHI | 113 | 7 | 36.6d | 0.96 |
| 9025880393 | premanand | 113 | 4 | 113.1d | 0.35 |
| 9600015136 | K VENUGOPAL / K VENUGO | 113 | 4 | 169.4d | 0.24 |
| 9600049099 | Ramaswamy | 113 | 3 | 140.9d | 0.32 |
| 9789220146 | DEEPTHA VENKATESAN, NA | 113 | 3 | 9.5d | 4.75 |
| 9840871590 | Saraswathi | 113 | 3 | 97.9d | 0.46 |
| 9940664379 | magesh / Mahesh | 113 | 3 | 101.7d | 0.44 |
| Category | Total | Streets | Complainants | Spread |
|---|---|---|---|---|
| No Water Supply | 27 | 1 | 14 | |
| Sewer Main Block | 19 | 1 | 8 | |
| Sewer - House Block | 1 | 1 | 1 | |
| Water Short Supply | 1 | 1 | 1 |