Support tickets
Helpdesk tickets from a fictional telecom provider, some still open.
What's messy
- Closed is blank for open tickets
- Channel names to standardise
Columns
| Column | Type | Note |
|---|---|---|
| TicketID | text | |
| Opened | date (yyyy-mm-dd) | |
| Closed | date (yyyy-mm-dd) | Blank if open |
| Priority | text | |
| Channel | text | |
| Agent | text | |
| Topic | text |
Try these
- Days to close (null for open)
- Tickets by channel and priority
- Flag billing topics
How to approach it
Set Opened and Closed to the date type first. The blank Closed cells become null, which is what you want for tickets that are still open. Days to close is Duration.Days([Closed] - [Opened]), and it returns null for open tickets on its own because arithmetic with null gives null. Don't replace those nulls with 0, or the average time to close will look better than it is. Then group by Channel and Priority with Count Rows, and count open tickets separately by filtering Closed to null.
Preview (first 8 rows)
| TicketID | Opened | Closed | Priority | Channel | Agent | Topic |
|---|---|---|---|---|---|---|
| T1000 | 2026-03-21 | 2026-03-23 | Low | Idris | Outage | |
| T1001 | 2026-03-02 | 2026-03-03 | Medium | Lena | Outage | |
| T1002 | 2026-02-02 | null | Low | Phone | Omar | Billing |
| T1003 | 2026-05-11 | 2026-05-11 | Low | Amara | Upgrade | |
| T1004 | 2026-04-10 | null | Medium | Chat | Lena | Billing |
| T1005 | 2026-04-15 | 2026-04-18 | Medium | Phone | Priya | Outage |
| T1006 | 2026-02-19 | null | Urgent | Chat | Dmitri | Outage |
| T1007 | 2026-03-10 | 2026-03-11 | Medium | Bao | Upgrade |
All data is fictional. CSV cells that could be read as spreadsheet formulas are prefixed with an apostrophe.