[FE] 39.19 As Pixally Owner, I can view revenue reports with configurable date presets (Today, Last 7/30/90/365 Days, This Quarter default, Custom Range), 4 KPI cards (Total Revenue, New Paid Subscribers, Churn Rate, CAC placeholder), 3 interactive charts

FRD Link
https://docs.google.com/document/d/1B2FP_sS96tjbl-wZKrIzRSfOzxAie5oEO8A11txFooE/edit?tab=t.bk2igj5um1ky#heading=h.qrtgqfk68u83

Figma Link
https://www.figma.com/design/ej0kxwP45mDKmZCZfAJ5O8/Pixally?node-id=31331-21275&t=ggr1H3F3XW6HE1m8-0

User Flows
FRD7 – Date filter selection flow, KPI card display, chart interaction (hover tooltips, legend toggle), Discount Code Usage table display, Export PDF flow

Functional Logic
FRD7 – Date filter logic (This Quarter default; presets: Today, Last 7/30/90/365 Days, Custom Range with end > start validation); KPI card calculations (Total Revenue = Subscription + Extra Seat + Transaction Fees; New Paid Subscribers count; Churn Rate = cancelled/total × 100%; CAC = 'Coming in v2' placeholder); Total Revenue Overview chart (line + bar, 3 data series: Subscription, Extra Seat, Transaction Fees); Revenue by Subscriptions chart (stacked bar, 4 plan types); Revenue by Service Types chart (pie, 4 agency types); Discount Code Usage table (all codes including deleted, columns: Code, Type, Discount, Usage Count, Revenue Impact, Status; Revenue Impact = sum of discounts applied); PDF export (filename: Pixally_Reports_[StartDate]_to_[EndDate].pdf, contains all KPI cards + 3 charts + discount table)

Acceptance Criteria
FRD7 – Default date filter is 'This Quarter' on page load; all presets and custom range filter KPI cards and charts correctly; custom range end before start → inline error; Total Revenue KPI sums all 3 revenue types; CAC shows 'Coming in v2'; all 3 charts render with correct types and legends; Discount Code Usage table shows active and deleted codes with correct Status column; deleted code appears with 'Deleted' status; Revenue Impact shows correct negative impact; Export PDF downloads with correct filename format; exported PDF contains all KPI cards, charts, and discount table; hover tooltips show values on charts; legend click toggles data series visibility

Edge Cases
FRD7 – Future date range selected → charts show empty state, KPIs show 0 or '--'; Today filter with no transactions → KPI cards show $0/0; Export PDF server error → error toast, no file downloaded; no data in period → chart empty axes with placeholder

Test Cases
TC-REP-001, TC-REP-002, TC-REP-003, TC-REP-004, TC-REP-005, TC-REP-006, TC-REP-007, TC-REP-008, TC-REP-009, TC-REP-010, TC-REP-011, TC-REP-012, TC-REP-013, TC-REP-014, TC-REP-015, TC-REP-016, TC-REP-017, TC-REP-018, TC-REP-019, TC-REP-020, TC-REP-021, TC-REP-022, TC-REP-023, TC-REP-024, TC-REP-025, TC-REP-026, TC-REP-027, TC-REP-028, TC-REP-029, TC-REP-030

Details

Key

PX-6251

Type / Priority

Status

QA Review

Sprint

Sprint 31

Epic

Super Admin Portal_Gawd Mode

Assignee

Kushal Brahmbhatt

Project

Pixally CRM

FRD

QA Status

—

Created

9/25/2026, 11:03:54 AM

Updated

9/25/2026, 11:08:34 AM

Last synced

9/25/2026, 11:08:34 AM
QA Test Cases

No test cases generated yet.

Failures & Comments (0)

No failures or comments.