Time maths done right
Response and resolution times use $dateDiff on real timestamps, and tickets without a response are excluded, not counted as zero.
Use case
Backlog by priority, first response time by channel, the issues behind most tickets: ask wuup in plain English and it queries your tickets collection read-only, then answers with a chart and the exact query, so you can trust the number you put in the weekly report.

Who it's for
Support leads and CX teams whose help desk data lives in MongoDB
Sources
The problem today
Ask in plain English. Here is what happens behind each answer, including the query when there is one.
Counts open and pending tickets for each priority.
db.tickets.aggregate([
{ $match: { status: { $in: ["open", "pending"] } } },
{ $group: { _id: "$priority", tickets: { $sum: 1 } } },
{ $sort: { tickets: -1 } }
])Uses $dateDiff between createdAt and firstResponseAt and averages it per channel.
db.tickets.aggregate([
{ $match: { firstResponseAt: { $ne: null } } },
{
$group: {
_id: "$channel",
avgMinutes: {
$avg: {
$dateDiff: { startDate: "$createdAt", endDate: "$firstResponseAt", unit: "minute" }
}
}
}
},
{ $sort: { avgMinutes: -1 } }
])Unwinds tags and counts them.
db.tickets.aggregate([{ $unwind: "$tags" }, { $sortByCount: "$tags" }, { $limit: 10 }])A simple find on priority and a null assignee.
db.tickets.find({
priority: "urgent",
assignee: null,
status: { $nin: ["resolved", "closed"] }
}, { _id: 0, ticketNumber: 1, subject: 1, createdAt: 1 })
.sort({ createdAt: 1 })
.limit(50)Averages csat where it exists and counts rated tickets.
db.tickets.aggregate([
{ $match: { csat: { $ne: null } } },
{
$group: { _id: "$assignee", csat: { $avg: "$csat" }, rated: { $sum: 1 } }
},
{ $sort: { csat: -1 } }
])Joins tickets to customers and groups by plan.
db.tickets.aggregate([
{
$lookup: {
from: "customers",
localField: "customerId",
foreignField: "_id",
as: "customer"
}
},
{ $group: { _id: { $first: "$customer.plan" }, tickets: { $sum: 1 } } },
{ $sort: { tickets: -1 } }
])Connect tickets and customers
Read-only, scoped to the two collections.
Ask about the backlog
"Open urgent tickets older than a day, by assignee."
Share the answer
Copy the table or the query into your report.
Response and resolution times use $dateDiff on real timestamps, and tickets without a response are excluded, not counted as zero.
Join to the customers collection to split metrics by plan or country.
Upload your support playbook PDF and ask whether a ticket was handled by the book, with citations.
No. wuup connects to MongoDB, Google Sheets and documents. If your tickets are synced into MongoDB or exported to a sheet, wuup can answer questions about them.
If the message text is in the collections you enable, yes. Consider leaving long free-text fields out of scope for faster, cheaper answers.