Johnny & Jugnu — NPS & Complaints (Weekly)

PDF-style view — filter by date and branch

Live (Apps Script)

From

To

Branch All

  Refresh

Loading…

Complaints Count

—

Total in range

Feedback Count

—

Total in range

NPS

—

Promoter% − Detractor%

Rated Responses

—

Prom/Neu/Det only

Complaints — Shift

Complaints — Source

Complaints — Channels

Complaints — Spark (Complaint Type)

Spark (Complaint Type) — % Distribution

Percent of total complaints in selected range.

Source × Shift (counts)

Source	Shift A	Shift B	Total

Top Complaint Heads (Outliers)

Complaint Head	Count

NPS — Promoter / Neutral / Detractor

Promoters: —%

Neutrals: —%

Detractors: —%

Top Feedback Outliers (by text)

Description	Count

Pulled from Feedback sheet's Description column.

Inbound Complaints (Source → Type → Top Heads)

Populate when a specific branch is selected (not All).

Source	Type	Top Heads

Branch Summary (All branches in range)

Counts and NPS per branch (same range).

Branch	Complaints	Feedbacks	NPS	Top Type	Top Head