GitLab Duo and SDLC trends dashboard (ClickHouse)
### Overview This epic tracks the upcoming enhancements for the Duo and SLDC trends dashboard, which is backed by ClickHouse and requires the Enterprise Duo add-on. The aim of this dashboard is to display GitLab Duo usage data as well as SDLC trend data to enable customers to both understand how their GitLab Duo licenses are being used as well as how GitLab Duo usage correlates with SDLC trends. ### Focus areas #### Providing more insight into GitLab Duo usage We need to provide as much meaningful GitLab Duo data as possible. The list below contains our immediate next steps. * Duo usage metrics table (6 months data comparison table) * Duo Code Review * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/573979+s~~ * This includes: * Total Duo Code Reviews over time * Total Duo Code Review comments over time * Duo Agent Platform (DAP) * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/570563+s~~ * Total DAP sessions * Average session duration * Root Cause Analysis (on-hold) * https://gitlab.com/gitlab-org/gitlab/-/issues/579952+s * Duo feature charts (6 months data comparison visualizations) * Duo Code Suggestions * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/454809+s~~ * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/573972+s~~ * https://gitlab.com/gitlab-org/gitlab/-/issues/550064+s * Duo Code Review * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/574003+s~~ * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/574005+s~~ * User specific metrics (user activity over the past 30 days) * A table will be introduced which helps customers explore how their individual seat are being used. * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/574420+~~ * Minor bug fixes still being worked on for the item above * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/574426+~~ * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/574435+~~ * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/574444+~~ * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/574451+~~ * Feature retention over time * https://gitlab.com/gitlab-org/gitlab/-/issues/576752+s * Most used Duo features * https://gitlab.com/gitlab-org/gitlab/-/issues/576755+s * Duo Agent Platform * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/581554+s~~ * https://gitlab.com/gitlab-org/gitlab/-/issues/581894+s #### Quality We need to make sure that the data we are displaying makes sense and is as accurate as possible. Where any confusion may arise, we need thorough documention which explains caveats. * ~~https://gitlab.com/gitlab-org/gitlab/-/issues/568860+s~~ * Feature flag has been enabled in 18.6 * https://gitlab.com/groups/gitlab-org/-/epics/19427+s * Work in progress * ~~WebIDE does not yet send event data~~ * ~~This is being resolved in https://gitlab.com/groups/gitlab-org/-/epics/17153+s~~ * This was shipped in 18.5 #### Scaling the dashboard with GitLab Duo features * https://gitlab.com/groups/gitlab-org/-/work_items/20113+s * https://gitlab.com/gitlab-org/gitlab/-/work_items/582153+s * https://gitlab.com/gitlab-org/gitlab/-/issues/571762+s ### Related items of importance * A number of initial designs were put together when we planned on building 2 separate CH dashboards. These designs can be referenced to help inform decisions we make about the Duo and SLDC trends dashboard. * https://gitlab.com/gitlab-org/gitlab/-/issues/505532+ * Related to this is a more technical breakdown of potential visualizations which could be added * https://gitlab.com/gitlab-org/gitlab/-/issues/570320+s
epic