📋
0
Total Complaints
0
Pending
0
Closed
🔥
0
Hotspot Areas
Date From
Date To
District
Tehsil
Category
Status
Map Layers
Radius
💡 Click map to analyse radius
🗺️ Complaint Map
0 complaints
District
Tehsil
Date Range
📈 Complaint Trends Over Time
📊 Tehsil-wise Comparison
✅ Status Distribution
🗂️ Category Breakdown
📅 Daily Complaint Volume
Date From
Date To
District
Tehsil
Cluster Radius
Threshold
🔴 High Risk — Immediate Action Required
⚠️ Problematic Areas Map
🔴 High-Risk Clusters
⚠️
Click "Detect" to find clusters
⬆️ Data Upload Center
Upload once — everyone with the link sees the same live data automatically
Checking…
☁️
Records in Database
👥
Live Sharing
Team sees data instantly
🔐
PIN Protected
Upload Security
📂 Upload New Data
⚠️ Uploading replaces ALL existing data. Team members see the new data immediately after upload.
📂
Drop file or click to browse
Excel (.xlsx, .xls) or CSV (.csv) · Saves to cloud database
🔐 Upload (PIN Required)
⚠️ About Problematic Areas

The Problematic Areas tab automatically detects high-risk complaint clusters on the map. After uploading your data, follow these steps:

🗺️
Go to Problematic Areas tab
Select your cluster radius and threshold
⚠️
Click Detect
System finds all high-risk zones automatically
📍
Click any cluster
View exact location on map or open in Google Maps
🤖
Get AI suggestions
Receive recommended actions for each high-risk area
📄
Download PDF Report
Generate a full report with maps and complaint list
💡 Tips for Best Results
📅Keep data updated weekly for accurate hotspot detection
📍Ensure Location column has correct lat,lng coordinates
🏙️Include Tehsil column for better area filtering
📊Use Analytics tab to track complaint trends over time
🗺️Load a KML boundary file to analyse specific zones
🤖 AI Assistant
Ask questions about your uploaded complaints data in plain English.
Suggested Questions
${["How many complaints were received yesterday?","Which tehsil has the most pending complaints?","What is the most common complaint category?","How many complaints are closed this month?","Which district has the highest complaints?","Show me complaints summary by status"].map(q=>``).join('')}
🤖
Hello! I'm your Complaints AI Assistant
Upload your data first, then ask me anything about your complaints.
Press Enter to send • Shift+Enter for new line • Answers are based on your uploaded data only
⚙️ Settings
Customise your tool's branding and appearance.
🏷️ Branding & Identity
Tool Name
Organisation Full Name
Logo Text (2-3 characters)
Footer Credit Text
Logo Colour 1 (Dark)
Logo Colour 2 (Light)
Live Preview
SGWMC Analytics
Done!