Dashboards / Support & customer success

Describe your dashboard. SluiceData builds it.

Tell the AI analyst what you need to understand. It connects your helpdesk and CRM, defines the metrics, builds the dashboard — and proves every number back to source. One conversation, not a project.

You

Show me how support is doing: ticket volume, average resolution time, CSAT, and how big the open backlog is right now.

SluiceData

Here's your support & customer-success dashboard, built on your Zendesk and CRM data — in your own cloud. Here's what's in it, and how each number is proven ↓

support_ops · your cloud Illustrative data

Ticket volume

4,820 ▲ 7.9%

tickets · COUNT(DISTINCT)

Avg resolution

14.2h ▼ 8.1%

avg(resolved − created)

CSAT

4.6 ▲ 0.2

avg(csat_score)

Open backlog

312 ▲ 4.4%

status not in closed

Ticket volume over time

weekly

Tickets by priority

this month

Low2,180

Normal1,520

High820

Urgent300

By priority

Priority	Tickets	Avg resolution	CSAT	Backlog	SLA
Urgent	300	3.1h	4.4	18	met
High	820	9.8h	4.5	64	met
Normal	1,520	19.6h	4.6	141	at risk

Here's what's in it — and how it's proven

Every number traces back to its source.

Click any KPI and see its formula → the exact compiled SQL → the source tables, and proof it reconciles. Resolution time is a derived column built in Silver — a dialect-correct date difference between the open and close timestamps. The AI planned it; deterministic code computed it.

metricAvg resolution time = 14.2h

formulaavg(resolution_days) — days between open and close

derivedresolution_days = DATEDIFF(created_at, resolved_at)

compiled SQLSELECT AVG(resolution_days) FROM tickets

sourceszendesk.tickets · created_at + resolved_at + status + csat

reconciled✓ counts tie to the helpdesk's own ticket report

Anatomy

What belongs on a support dashboard.

Who uses it

Support and customer-success leads managing SLAs, staffing and the health of the queue.

Refresh

Daily, as tickets open and close. A backlog building or resolution time slipping surfaces automatically.

Honest by default

Health-score churn risk needs a usage + renewal model. Where that data isn't connected the metric is skipped and reported — never a made-up score.

Describe the dashboard you need. Get it this week.

Connect your helpdesk and SluiceData builds your first governed, provable dashboard — in your own cloud.

Book a demo