CMWSSB Complaint Analytics

Street	Depot	Sewer	People
Srinivasaperumal Sannathi II Street	118	50	17
Muthiah Street	118	49	21
Pirasanna Vinayagar Koil 1St Street	118	38	13
Govarthan Street	118	37	11
Ponnusamy Street	118	34	20
Avvai Shanmugam Salai	118	33	15
Pillaiyar Koil Street	118	30	17
Nattu Muthu Street	118	27	16
Varatharajapuram Main Road	118	26	16
Parthasarathy Pettai	118	24	13

🚰 Water Complaints (no supply · short supply · leaks)

CSV PDF

Street	Depot	Water	People
Avvai Shanmugam Salai	118	20	10
Pirasanna Vinayagar Koil 1St Street	118	15	7
Pudupet Garden Street	118	13	10
Anna Salai From Teynampet Signal To Kamarajar Arangam	118	10	4
Thomaiappan Street	118	9	5
Kanakasree Nagar	118	8	4
Ganapathy Street	118	7	5
J.j Road	118	7	6
Poes Garden	118	7	5
Rajakrishnarao Road	118	7	5

💧 Water Pollution (pollution complaints)

CSV PDF

Street	Depot	Pollut.	People
Thomaiappan Street	118	13	2
Srinivasaperumal Sannathi II Street	118	12	5
Sriman Srinivasan Road	118	10	7
Mariyappan Street	118	8	5
Shanmugam Street	118	8	3
Muthiah Street	118	7	3
Varatharajapuram Main Road	118	7	4
Ganapathy Street	118	6	2
Venkatarathinam Salai	118	5	2
Besant Road	118	4	2

🔁 Recurrence — how often the same issue comes back (same category · same street)

PDF

Category	Street	Depot	Times	Span (days)	Avg gap (days)	Per month
No issue recurred often enough in this scope.

Avg gap = average days between consecutive complaints of that type on that street. Lower gap / higher “per month” = a faster-recurring, unresolved problem.

🔬 Advanced Analysis

Pareto — the vital few (which categories drive most complaints)

Categories ordered by volume with their cumulative share. The highlighted rows are the smallest set that together account for ~80% of all complaints — fix these first.

Category	Count	Share	Cumulative
Hand Pump Repair vital	3	100%	100%

When complaints arrive (weekday × time of day)

Load pattern across the week — darker cells are busier six-hour windows. Useful for staffing and planning proactive checks before the peak.

	Night	Morning	Afternoon	Evening	Total
Mon					0
Tue					0
Wed					0
Thu		1			1
Fri					0
Sat		1			1
Sun		1			1
Total	0	3	0	0	3

Linked problems (category pairs that hit the same streets)

Pairs of issue types that recur together on the same street, ranked by the number of streets where both appear. Strong pairs point to a shared root cause worth fixing in one visit.

Problem A	Problem B	Shared streets
Not enough overlapping complaints in this scope.