AI Impact - [BE] Root cause analysis users - Count of users selecting /troubleshoot

Problem to solve

Proposal - Adding Root cause analysis of unique users over [insert period]

Add tracking of Root cause analysis of unique users over [insert period] - we want to correlate the adoption of Duo RCA with decreasing lead and cycle time:

• RCA User Journey: Go to Failed Job (via Pipelines or MR) > Select the Troubleshoot button under the console output > Duo chat opens with /troubleshoot command > Read root cause > Implement fix in MR > MR Pipelines pass > Merge MR

Metrics:

• rootCauseAnalysisUsers - Count of users selecting /troubleshoot within a failed pipeline

Acceptance Criteria

Backend:

• Update the executor for troubleshoot job to include the ai troubleshoot job tracking
• GraphQL aiMetrics includes rootCauseAnalysisUsers

UX/Frontend:

• rootCauseAnalysisUsers is incorporated into the AI Impact dashboard

Technical details

Create new ClickHouse table for "troubleshoot" events. Besides common event fields the table should include ci_job_id and ci_pipeline_id as reference to specific job or pipeline.