User-Reported Issues
User-Reported Issues: Number of bugs/issues reported by users.
Formula
User-Reported Issues = Count of user-submitted bug reports Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
count_distinct(field.issue_id where field.issue_type = 'bug' and field.issue_source = 'user_report') Unit: count
Data requirements
Grain: Per event, aggregate monthly · Frequency: Daily · Aggregation: aggregate (month) · Staged: no · Main source: Product Analytics.
| Field | Dataset | Type |
|---|---|---|
created_at | issue | timestamp |
issue_id | issue | string |
issue_source | issue | string |
issue_type | issue | string |
Example SQL (Postgres)
SELECT (SELECT COUNT(DISTINCT issue_id) FROM issue WHERE created_at >= :period_start AND created_at < (:period_end + INTERVAL '1 day') AND (issue_type = 'bug' AND issue_source = 'user_report')) AS user_reported_issues From an agent: with the GASP MCP server, call
lookup_metric({ "name": "User-Reported Issues" }) or generate_query({ "metric": "User-Reported Issues", "adapter": "<your adapter JSON>" }).
What It Tells You
Quality as perceived by users.